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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: