devxlogo

Common Stored Procedures

Common Stored Procedures

Question:
I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do changes on all other databases. Is there any way to create stored procedures for common use?

Answer:
I think the answer is to name them “sp_” (normally not recommended) and store the common ones up in Master. However, that has its own peculiarities, in that you will be invoking those Master stored procedures from whatever database you happen to be in.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist