>You can put the stored procedure in the master database and prefix the name with sp_. When you want to execute it, do so from the database of interest. Since the proc's name begins with sp_, SQL Server will first look in the master database. Finding it there, SQL Server will execute it in the context of your database.
>
>-Mike

That is very useful info, Mike. Thank you.