December 4, 2014

Need to search strings inside your SQL Objects? Try this utility

Written by

While performing a migration from SQL Server 2000 to SQL Server 2014 (wow what a big jump), I needed to find all stored procedures that made a call to an extended stored procedure that was being replaced with functionality that is baked in to more recent versions.

So what to do? Stack Overflow had a few good suggestions, but Red Gate’s SQL Search came out on top. If you have a ability to install it (hard to do at some clients) then it’s a great option.

Figure: Find all TODO’s

Category : SQLTSQL

Leave a Reply

Your email address will not be published. Required fields are marked *