SQL SERVER – Find Table in Every Database of SQL Server – Part 3

Previously I wrote two articles about
SQL SERVER – Find Table in Every Database of SQL Server

SQL SERVER – Find Table in Every Database of SQL Server – Part 2

I recently received email from SQL Expert and Blog Reader Greg Steinkuhler. People like Greg Steinkuhler makes this whole world better place. He wrote absolutely wonderful script which runs on network and have shared with community. Hats Off to you!

His original email is listed here:

Hi Pinal Dave,

After reading the article on your website in reference to “Find Table in Every Database of SQL Server” I tried to see what I could do. In the long run I wasn’t able to make “sp_msforeachdb” work because I added a feature to go out on the network and I didn’t see how to make this system stored procedure work remotely. Anyhow, if you would like to post my stored procedure for others to use this is what I came up with.

Download sp_FindSQLObjectsAndReferences.sql

Thanks,

Greg Steinkuhler, another fan of your SQLAuthority.com website

Reference : Pinal Dave (https://blog.sqlauthority.com) , Greg Steinkuhler

, ,
Previous Post
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
Next Post
SQL SERVER – Ideal TempDB FileGrowth Value

Related Posts

Leave a Reply

Menu