Put it in the master db then call it exec master..spname. Make sure that the calling id has execute rights to the sp. Also it can be in any db and called via exec dbname..spname.
Joshua Tipton -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:27 PM To: SQL Subject: Global SP Is there a way in SQL 2k to write a stored procedure in one place (master for example) and have it accessible in any other location? Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
