SQL HELP

[sanbk]

Oka table dependency across all stored procedures across all databases ki script cheppandii.... 

[MOD]

[BongaralaLingaraju]

[former]

13 minutes ago, sanbk said:

Oka table dependency across all stored procedures across all databases ki script cheppandii.... 

Oracle or SQL Server ?

[sanbk]

SQL Server

[compose]

[Sambadu]

http://blog.sqlauthority.com/2010/02/04/sql-server-get-the-list-of-object-dependencies-sp_depends-and-information_schema-routines-and-sys-dm_sql_referencing_entities/

[sanbk]

7 minutes ago, Sambadu said:

http://blog.sqlauthority.com/2010/02/04/sql-server-get-the-list-of-object-dependencies-sp_depends-and-information_schema-routines-and-sys-dm_sql_referencing_entities/

Bro adi only current database ki work avuthadi not across all databases for that server

[sanbk]

Evaru leraa experts LTT.....

[jailokesh]

Help

[Leonardo_Di_Carpio]

table mida...right click chesi....dependency select chesthe....list of stored procedures vasthai....try it...

[sanbk]

3 minutes ago, Leonardo_Di_Carpio said:

table mida...right click chesi....dependency select chesthe....list of stored procedures vasthai....try it...

adi vasthadi but okka database ki prathi table ala chesi choodalemu kada dynamic gaa table name isthee ah server lo unna anni databases(20+) stored procedure dependencies ravalii 

[Leonardo_Di_Carpio]

33 minutes ago, sanbk said:

adi vasthadi but okka database ki prathi table ala chesi choodalemu kada dynamic gaa table name isthee ah server lo unna anni databases(20+) stored procedure dependencies ravalii 

this is very reliable in-built functionality...in SQL

script is not relaible...hope you understand....