SQL stored procedure to search an entire database

I don’t often re-post things from other blogs, but this is just too good not to share. David Musgrave recently published an update to his spSearchOnAllDB stored procedure on his blog, Developing for Dynamics GP.

Simply run the script to create the stored procedure and you can search all the tables in a database for a particular string or value. You might not need this frequently, but when you do – what an incredibly powerful tool to have.

Check out David’s post to download the script and see notes about usage. Thanks David!

You can see links to other helpful SQL Server tips on my SQL Server Coding Tips page.


  1. SQL stored procedure to search an entire database – 7/22, Victoria Yudin | - July 22, 2013

    […] Continue reading on Source Blog […]


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 )

Connecting to %s

%d bloggers like this: