[dba-SQLServer] SQL 2005 Server Management Studio

John,

When you right click on a stored procedure, and select modify, it 
comes up in an ALTER format.  If you save them to the hard drive, 
they are NOT in the database. You have to edit and save them in the 
database itself.

Robert

At 10:56 AM 1/26/2006, you wrote:
>Date: Thu, 26 Jan 2006 10:50:16 -0500
>From: "John Colby" <jwcolby at ColbyConsulting.com>
>Subject: [dba-SQLServer] SQL 2005 Server Management Studio
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <006901c62290$34914b10$6f00a8c0 at ColbyM6805>
>Content-Type: text/plain;       charset="us-ascii"
>
>I am having a "conceptual issue" using the SMS.  I create a stored procedure
>and it saves to a directory out on the hard disk.  Somehow I managed to get
>a couple of them showing in the stored procedure window but I don't know how
>so I am not seeing the rest of the SPs I am adding.  Additionally, if I
>click one that does show in the SP window in the database in SMS, and say
>"modify" it opens it in the edit window as a new query with just SPnn as the
>name, where NN is a number.  Then when I try to save it it asks where I want
>to save it.  So I am not "editing" the original, but creating a copy and
>editing that.
>
>Is anyone out there using this thing and if so how do I save (and see)
>stored procedures in a given database, and ten edit that SP directly later?
>
>John W. Colby