maillist at kkendrick.net
maillist at kkendrick.net
Thu Jan 26 14:08:23 CST 2006
John, When you create the stored procedure with the CREATE PROCEDURE syntax, then execute it, it is saved to SQL Server 2005. When you modify the stored procedure with the ALTER PROCEDURE syntax, then execute it, it is again saved to SQL Server -- with the modifications. You also have the option of saving it to disk. If you don't want to save it, then you just close it. HTH. Kay Kendrick -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Thursday, January 26, 2006 12:18 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio >You have to edit and save them in the database itself. And you do that by..... Part of the problem here I suspect is that I am out on the bleeding edge trying to use SQL Server 2005 which has a brand new widget for management called Microsoft SQL Server Management Studio Express. The old tools don't work with 2005. And (apparently) no one on this group is using this thing. And then of course I am clueless to start with, never having done any of this before. I really don't want to spend my time learning the tools for SQL Server 2000 (I have actually used them a fair amount) because I am "selling" 2005 Express (can you say FREE? An easy sell!) to my clients. As such I need to learn the tools for 2005 Express. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Thursday, January 26, 2006 12:18 PM To: dba-sqlserver at databaseadvisors.com Cc: jwcolby at colbyconsulting.com Subject: Re: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com