One of my tables showed 33 dependent stored procedures before I dropped the table for a maintenance and change cycle. Is executing a CREATE on the stored procedure the only way to reestablish those stored procedure dependencies?

SQL Server's automatic dependency tracking feature isn't very reliable, and SQL Server doesn't support retrieving the information unless you recreate each object that depended on the table. Microsoft is working on removing this limitation for a future release.

End of Article


You must log on before posting a comment.

If you don't have a username & password, please register now.

Reader Comments

try running sp_wtf

Anonymous User- November 03, 2004

THANKS - IT works GREAT!!!!

Anonymous User- November 03, 2004