Mark database objects as "global" across SQL Server instance
We need means of marking database objects as "global" across the SQL Server instance. Similar to designating the "sp_" prefix, Best Buy would like to mark a UDF or stored procedure as globally executable and local to each user database - without making multiple copies of the same object.
This was done (although not supported) in 2000 with undocumented system stored procedures and using sp_ prefix.
Best Buy creates a number of maintenance stored procedures and functions, which are used by DBAs to manage user databases. Instead of duplicating code in each database we are creating them in master database with sp_ prefix (for stored procedures) and executing from specific user database. In some cases system tables are used, that should be local to the user database instead of master. In this case stored proc would reference tables in master database instead of the user database.
This improvement would help with code-reusability, maintainability, and overall supportability.
AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
Upvotes: 1
<=-=Dec 10 2007 11:25AM=-=>Hi,
Thanks for your feedback on this. We are looking into this feature request for enabling global procedures. We will investigate this further and if appropriate, take it up in a future release. Please feel free to contact us with any comments/suggestions.
Hi,
Thanks for your feedback on this. We are looking into this feature request for enabling global procedures. We will investigate this further and if appropriate, take it up in a future release. Please feel free to contact us with any comments/suggestions.
Hello,
I have resolved your request as duplicate of one below:
http://connect.microsoft.com/SQLServer/feedback/details/310064
—
Umachandar, SQL Programmability Team