Take the 2-minute tour ×  My SQL Server 2008 has    1. one
central database that has some global functions, e.g. mapping to
specified client DB.   2. 50+ client DBs   3. Master DB.. (MS
Default)   4. ASPState for session.  Now I'm trying to add this
stored procedure usp_RethrowError (http://msdn.microsoft.com/en-
us/library/ms179296.aspx) which is return a message from
try...catch.. of SQL to my server.  Since the stored procedure
is a common sp, I want to use it in the central DB and all
client DBs. Where should I put it? in the central or duplicate
it in each client DB?  Is there any issue or performance
drawback if the stored proc is placed in the central, caz in the
client DB, I have to write something like
[central].dbo.usp_RethrowError  What about put it in the master
db?  Many Thanks  share|improve this question add comment  3
Answers  up vote 2 down vote accepted  This question is largely
a matter of taste, and of the specific circumstances. There are
no performance implications to calling a procedure