Exec sp_depends I have learned today shows what tables are in a specific view or sp but im noticing it only shows the tables that are in that database. Is there a way to show all tables from all tables that are in that database.
View 6 RepliesDoes anyone know of a system SP to produce a listing of all tables and their dependancies and/or a list of all the stored procedures and their dependancies as opposed to looking at each one seperately?
Thanks!
Hi, in Management Studio I was able to view a list of dependancies for a table, both those Objects the table depended on, and Objects that depended on it; specifically a set of stored procedures. After modifying the table by adding several columns and updating the relevant stored procedures, the list of dependacies was gone. Once I executed the two stored procedures I had modified, they appeared in the list of dependancies for the table.
Originally there were more than two procedures listed as dependant on the table, but they only selected from the table based on a pre-existing column,so they didn't need to be modified when the additional columns were added. I suspect that the graph of dependacies is created when the stored procedures are compiled, but I'm not sure.
Is there any way to force the database to recalculate dependancies, or at least those for a specific table?
Hey,
To reduce the load on my current server I wish to move a table which is being updated frequently by a static feed to an independant server.
Is there any way of moving a table with all of it's dependancies (Stored procedures and other tables) to another server without manually finding them all.
I'm very new to this as you can tell so if you require specifics let me know :)
Jim
Why don't you folks (SQL SERVER Management Studio Team or SQL SERVER Database Engine Team) provide an option by using which I would be in a position to know what all the other objects are depended on a selected object and vice versa. That means:
When I select a Table within the SQL SERVER Management Studio if there is an option for understanding "Which all the objects (tables or views) it is depended on (I mean Foreign key and etc... kind of relations) and also Which all the objects (Tables, Views, Stored Procedures and etc...) are using this table", It would be of great help for all developers.
I can be contacted over kotis@microsoft.com
I BLOG @ http://blogs.msdn.com/kreddy