[dba-SQLServer] SQL 2005 Server Management Studio

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




More information about the dba-SQLServer mailing list