View Full Version : [SQL Server 2000] Where to save a stored procedure

Jul 27th, 2006, 05:58 PM
I am using SQL Server 2000. I created a Stored Procedure using the query analyzer. Then I executed the query.

If I want to save the stored procedure I wrote can I save any where I want or I have to save it in the Databases > Stored Procedures folder?


Jul 27th, 2006, 06:14 PM
Go into enterprise manager, open your db, then go to stored procedures, it should be their. You can make them in enterprise manager as well.

Good luck;

Jul 27th, 2006, 06:54 PM
Ok, thanks