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.