This is an alternative for "Encrypting all Stored Procedures of a Database".
read more
You can search for any string with in the TSQL scripts of all the Stored Procedures in a database using the syscomments table. Read Post
Not necessarily an alternative, but a wrapper. I created it as a quick stored proc, and put it in the master db, so it can be used in any database.Usage: exec fi 'last_name'.USE [master]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONG... Read Post
encrypt all stored procedures in SQL server with powershell Read Post