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 www.ColbyConsulting.com