Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, July 4, 2017

How to find all procs in a DB which cross reference other databases

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

No comments: