Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to update the table sysdepends

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-26 : 07:03:45
Kim writes "How to update the system table called sysdepends.

When I want to have a list of all stored procedures that is related to a particular table, I usually do sp_depends 'my table'. For example, I drop all stored procedures in my database A and I make a Create script to generate all Stored procedure of database B into A. At that time, my sysdepends table is corrupted. But my sysdepends table has not been populated correctly."

   

- Advertisement -