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 (http://blog.SQLAuthority.com) , Greg Steinkuhler

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s