Global Stored Procedures


New Member
Is there a means in MSSQL2005 whereby I can define globally accessible stored procedures without messing around with system level objects that could potentially change with patches, etc? I'm not referring to a solution utilizing dbname..my_global_proc - I'm talking about something not requiring any definition at the local db level. I.e., could be called like this from any db on the server:

exec my_global_proc

Thanks in advance,