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