Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SqlServer

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-18 : 09:48:48
ElayaRaja writes "I have written a Stored Procedure in a Database Emp_Data1
and the Stored Procedure used is Test_sp. I want to run this Stored Procedure in Other Database without using Emp_Data1..Test_sp . I have to just give Test_sp and run. In Short I want to make my Userdefined Stored Procedure to be public to all."

Nazim
A custom title

1408 Posts

Posted - 2002-04-18 : 10:03:29
Try this though am not sure whether it work

rename the stored procedure starting with sp_ . create the sp in master database .


--------------------------------------------------------------
Go to Top of Page
   

- Advertisement -