RE: Distributed Stored Procedures
From: Dragan Babovic (dragan_at_babovic.net)
Date: Fri, 27 Feb 2004 16:06:06 -0800
You could consider to rename all SPs by adding sp_ prfix and move them to master database. Then when you call them from any database they will execute like they are in the db they are called from. This works only if everything is happening on the same server/instance.
You could test the concept with a few SPs first.