[dba-SQLServer] SQL 2005 Server Management Studio

John Colby jwcolby at ColbyConsulting.com
Thu Jan 26 09:50:16 CST 2006

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

More information about the dba-SQLServer mailing list