[dba-SQLServer] Another Express question

Jim Lawrence accessd at shaw.ca
Thu Jan 12 18:56:50 CST 2006

Hi Susan:

I am not sure what the issue is but when I am building a SP, I may use the
template to initiate the creation, make any appropriate changes to match my
requirements, test until the desired results ate obtained, create a new SP
and cut and paste resultant query into the new SP. I understand you can
create your own templates but should not be able to over-write system the


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Sent: January 12, 2006 12:15 PM
To: SQL Server List
Subject: [dba-SQLServer] Another Express question

Has anyone tried Management Studios query editor to create a stored
procedure? It seems a bit awkward -- I found it easier to use insert the
appropriate SQL statement into the template and execute it to save it. 
Any comments? Maybe I'm doing something wrong? 
In the stored procedure template, I clicked the Design Query button and used
it as if I were creating a view. It did update the template, but very oddly
-- the SQL statement was at the top of the template instead of inside the
CREATE PROCEDURE statement as I had expected. Perhaps the query editor isn't
really supposed to work with stored procedures? 
Susan H. 
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list