SQL server exams - Table dependencies

Author

Table dependencies

cocolocopolo

2002-05-11, 2:41 am

Now, I am in Page 170 (MCSE Training Kit), the second Bottom paragraph.

It says:

To view the dependencies of a table, use the sp_depends system stored procedure or use the Display Dependencies option in SQL Server Enterprise Manager.

So, I opened Query Analyzer, then typed as follows:

Use Northwind
Go

sp_depends

But got error:

Server: Msg 201, Level 16, State 4, Procedure sp_depends, Line 0

Procedure 'sp_depends' expects parameter '@objname', which was not supplied.

Then I tried open up Enterprise Manager, but just cannot find where is the "Display Dependencies" option.

What's going on ???

amyland

2002-05-11, 10:21 am

Examples
This example lists the database objects that depend on the Customers table.

USE Northwind
EXEC sp_depends 'Customers'

cocolocopolo

2002-05-11, 4:42 pm

Wow !!!

Thanks amyland.

Now I realized I did not type complete command line.

Thanks again.

Sponsored Links