[dba-SQLServer] SQL 2005 Server Management Studio

John,

Open The database.
Open Programmability
Right Click on Stored Procedures
Select Create New Stored Procedure

You are presented with a template for one.  If you have one from a 
file, open it in note pad and paste it in over the template.  Close 
it and save it.

Also, if you can get ahold of the developers version of SQL 2005, you 
can get the full version of SMS.

Robert

At 02:15 PM 1/26/2006, you wrote:
>Date: Thu, 26 Jan 2006 13:18:23 -0500
>From: "John Colby" <jwcolby at ColbyConsulting.com>
>Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <008301c622a4$e5665e30$6f00a8c0 at ColbyM6805>
>Content-Type: text/plain;       charset="us-ascii"
>
> >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