Previously I wrote two articles about
SQL SERVER – Find Table in Every Database of SQL Server
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.
Greg Steinkuhler, another fan of your SQLAuthority.com website
Reference : Pinal Dave (http://blog.SQLAuthority.com) , Greg Steinkuhler