...

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



chelvis
07-27-2006, 04: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?

Thanks

Brandoe85
07-27-2006, 05: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;

chelvis
07-27-2006, 05:54 PM
Ok, thanks



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum