• Cool, I'll try playing with that.

    What I'm trying to do is create a Stored Procedure that will take a string of text as a parameter, and then search all the database objects, in all schemas, within a given database, and return a table showing all the objects the string appears, or optionally, to do the same but ignore any object where the search string only appears in the comments. And I think I need to create it in the master database to make it available in all the other databases on my server.