Pentru a completa raspunsul initial:
In SQL Server 2000 - tool-ul Query Analyzer avea functionalitatea Object Search care facea exact ce va doriti.
In SQL Server 2005 din pacate odata cu Query Analyzer a disparut si Object Search (
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124498) insa puteti folosi ca model scriptul de mentionat anterior.
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro