Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Global Stored Procedures

Discussion in 'Database Design and Database Objects' started by tiggyboo, Apr 13, 2012.

  1. tiggyboo

    tiggyboo 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,

Share This Page