[SQL Server 2000] Where to save a stored procedure

[chelvis]

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]

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]

Ok, thanks