[dba-SQLServer] Another Express question

Susan Harkins harkinsss at bellsouth.net
Thu Jan 12 14:15:00 CST 2006


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. 



More information about the dba-SQLServer mailing list