How I TSQL search stored procedures for text fast
If you've ever inherited a massive legacy database, you know the struggle of trying to tsql search stored procedures for text just to find where a specific business rule is buried. It's one of those tasks that sounds simple until you realize there are five hundred procedures and you have no idea which one is actually touching the "Orders" table or calculating that weird "SummerDiscount" variable. I've spent way too many hours digging through folders in Object Explorer, and honestly, life is too short for that. ...