Reestablishing Stored Procedure Dependencies
Richard Waymire answers a reader’s question about dependency tracking.
Richard Waymire
October 23, 2001
1 Min Read
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.
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like