Editing Stored Procedures in Query Analyser

[Stedo]

hi,

A quick question. I am writing some procedures in the Enterprise manager for MS SQL. However the editing facilities are not great and I want to edit these procedures in Query Analyser. I can edit the procedures but I can't seem to save them back to the database. The procedures appear in a window (Untitled1) and when I save them it saves them to a file.

Can anyone help!

Thanks
Steve

 

[Jamfool]

When you open them in Query, they need to be run against the database. Which will alter the existing objects.


SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE procname
AS

...etc ...ec

 

[Stedo]

Thanks!

Steve