CodingForums.com - View Single Post - [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

07-27-2006, 04:58 PM	PM User \| #1
chelvis Regular Coder Join Date: Jun 2002 Posts: 406 Thanks: 0 Thanked 0 Times in 0 Posts	[SQL Server 2000] Where to save a stored procedure 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 Last edited by guelphdad; 07-28-2006 at 03:48 AM.. Reason: to identify the database used