By StarkMike - 5/16/2007
I'm trying to delete a table in sql server and it tells me that there are stored procedures and views that depend on this table and therefore i cannot delete it. I've looked into a few of these stored procedures and its not using the table. So why does it keep telling me there is a dependency?
Any adivce?
Thanks.
|
By Trent L. Taylor - 5/16/2007
More than likely there is still something that is referencing the table. This message is accurate as I have run into it myself many times  . The one things SQL Server Management Studio (and SQL Server at large for that matter) does is require the contraints and dependencies to be addressed before removing an element. Have you verified that there is not a view that uses this table? Are you possibly overlooking a stored proc?
|
|