mike55 Posted April 26, 2006 Posted April 26, 2006 Hi all I am working on a database that was created in sql sever 2000 and then imported into 2005. I am after finding a dependency that should not exist. What is the best approach for removing this dependency. Currently using google to find a possible solution. Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Administrators PlausiblyDamp Posted April 26, 2006 Administrators Posted April 26, 2006 Did the dependency exist before the upgrade? If so was it a valid dependency before or an already existing error? You might also want to try some of the DBCC commands and see if that can identify / repair the problem. (Backup recommended first...) Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
mike55 Posted April 26, 2006 Author Posted April 26, 2006 Solved the problem, used the following commands: ALTER [table name] DROP [constraint name] Appreciate the help. Mike55. Quote A Client refers to the person who incurs the development cost. A Customer refers to the person that pays to use the product. ------ My software never has bugs. It just develops random features. (Mosabama vbforums.com)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.