Removing Table dependencies in SQL SERVER 2005

mike55

mike55

Well-known member
Joined
Mar 26, 2004
Messages
726
Location
Ireland
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.
 
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...)
 
Solved the problem, used the following commands:
ALTER [table name]
DROP [constraint name]

Appreciate the help.

Mike55.
 
Back
Top