Editing stored procedures...

I'm not a "real" programmer. Excuse my ignorance.

I need to edit a stored procedure. I simply want to change the text that it displays. I do not intend to change its function.

I am using SQL Express and SQL Server Management Studio Express. I can select Modify for my stored procedure, but when I save it, it saves it as an SQL file to my hard disk. How do I affect the edits to the actual stored procedure?

Hi,

When you save the stored procedure you just save the sql statement (.sql file).
You have to execute the statement.

So : go to your Stored procedure
Select 'Modify'
Make the necessary changes
Execute the code ( press F5)

Succes,

Jef