• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Creating Stored Procedures and saving

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??
0
Isaac
Asked:
Isaac
  • 2
1 Solution
 
SwindleCommented:
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.
0
 
SQL_SERVER_DBACommented:
this is true, but it can be done without using the query analyzer just for the record.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now