Creating Stored Procedures and saving

Posted on 2007-10-01
Last Modified: 2010-03-19
I am using SQL Server 2005 and I having problems with stored procedures.
Whenever I create an SP and save it, it saves it here "My Documents" --> "SQL Server Management Studio" --> "Projects".

The problem: It does not appear in Microsoft SQL Server Management Studio in this folder "Programmability" --> "Stored Procedures" for the database that I'm working with.  I always have to connect to the server remotely to create my SPs.  Only then does it appear in the "Stored Procedures" folder.

What am I doing wrong??
Question by:Isaac
    LVL 16

    Expert Comment

    LVL 11

    Accepted Solution

    When you write a stored procudure you have to execute the CREATE PROCEDURE call to make it save to the server and be active.  Using file/save just saves the script to a specified location.
    LVL 16

    Expert Comment

    this is true, but it can be done without using the query analyzer just for the record.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how the fundamental information of how to create a table.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now