Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    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

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    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;

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    406
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok, thanks


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •