microsoft.public.sqlserver.programming

Hari

3/28/2007 3:51:00 AM

Try below

EXEC sp_depends 'tableName'

or

Query the system view "sys.sql_modules"

Thanks
Hari

"JohnE" <JohnE@discussions.microsoft.com> wrote in message
news:56704F33-F64F-4069-AD0B-3CB2DABDB81D@microsoft.com...
>I am relatively new to sql 2005. I am wondering if anyone has a sample of
>a
> search query that could be used to determine all stored procedures, views,
> etc that would be associated with a table? If anyone has a sample of such
> a
> search query and willing to share it, that would be great.
> Let me know.
> Thanks for the assistance.
> *** John