I would look into SQL Search by Redgate and see if that does what you're looking for. It's a free plugin for SSMS. If that doesn't work there may be other ways to get what you're looking for but I would start there first.