When in MS SQL server and you need to find some text in a stored proc, but you have 100′s of them, what do you do? Came accross sp_findtext when searching for an issue today. I was doing maintenance on an app I hadn’t looked at in over 18 months. sp_findtext