find which sprocs/views reference a table

Is there a quick way to find what sprocs/views reference a table within ?
Does sp_depends work accurately ?sp_depends can not be relied on if you cannot guarentee the database has been
built in the correct order. As far as we know we're the only provider of an
application that can do this.
regards,
Mark Baekdal
www.dbghost.com
+44 (0)208 241 1762
Living and breathing database change management for SQL Server
"Hassan" wrote:
> Is there a quick way to find what sprocs/views reference a table within ?
> Does sp_depends work accurately ?
>
>|||Hi Hassan
sp_depends has been notorious for years. If you want a quick, simple answer,
you can simply select the procs from syscomments where the name of the table
is in the text of the sprocs / views. Otherwise, I'd recommend you check out
SQL Scribe which is a nice 3rd party tool that does the trick nicely.
http://www.ag-software.com
Regards,
Greg Linwood
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u4w6JtIyEHA.3416@.TK2MSFTNGP09.phx.gbl...
> Is there a quick way to find what sprocs/views reference a table within ?
> Does sp_depends work accurately ?
>|||As mentioned, the dependency records in a SQL Server database can be
problematic.
The SQL Server Tools WT3 application addresses the problems. It can list
dependencies as reflected in the dependency records. It can list
dependencies as found with a text search. It can rebuild the dependency
records to their original/correct state. It can generate detailed database
documentation, including dependencies. All of this for $19, which is about
1/20 (5%) of a previously mentioned product.
Please visit http://www.sqlservertools.us for more information.
"Hassan" wrote:
> Is there a quick way to find what sprocs/views reference a table within ?
> Does sp_depends work accurately ?
>
>