Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Alberto De Rossi,
I use this short named procedure regularly to find different objects on different database. It's very simple and very practical. Of curse you need to have an Idea of whats on the database. Creating it on the master databse makes it available for searchs on any database in the server. It constructs dynamycally a query depending on the prameters u use. Feel free to make any changes.
Alberto De Rossi