SQLServerCentral » Latest topics
How to find all procs in a DB which cross reference other databases
Hi All
I need to find all procs from a database which reference tables from another databases. all my DB has just one schema :dbo
so e.g. if I have a proc Proc1 in DB1 and it refres to some table in DB2, it should come in my list.
I thought of
I need to find all procs from a database which reference tables from another databases. all my DB has just one schema :dbo
so e.g. if I have a proc Proc1 in DB1 and it refres to some table in DB2, it should come in my list.
I thought of
No comments:
Post a Comment