I wanted to search for a stored procedure within our server and did not know the exact database it was in. I tried a few things unsuccessfully but finally decided to google it. I came across this article on SQLServerCentral.com : http://www.sqlservercentral.com/articles/Advanced+Querying/howtofindsqlserverobjects/1446/ which seemed too complicated so I searched more and found a free application called SQLDBSearch which works wonders.
However, I'd much prefer a T-SQL query to search within my server through all databases for stored procedures or any other database objects. Any other idea's? Solutions, etc?
Thanks for all the help in advance.