Editing Stored Procedures in SQL 2005?

Question

Editing Stored Procedures in SQL 2005?

britinusa

SSC Veteran

Points: 278
More actions
October 25, 2012 at 8:19 am

#284038

Ok, so I am a little late ...
Migrating a db server from MS SQL Server 2000 to 2005.
In SQL 2000 editing a storedproc was easy. Properties ... edit away and save it.
How the **** does one edit an SP under 2005? Am I blind?
Robert

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

britinusa (10/25/2012)
Ok, so I am a little late ...
Migrating a db server from MS SQL Server 2000 to 2005.
In SQL 2000 editing a storedproc was easy. Properties ... edit away and save it.
How the **** does one edit an SP under 2005? Am I blind?
Robert

In the GUI: -

Right click then "Modify".

Or

Right click, then script stored procedure as, then alter, then to new query window.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

britinusa SSC Veteran Points: 278 More actions · Answer 2

Did Google this first and it seems some SQL 2005 do not have the Design option.

So one literally has to run an ALTER rather than in 2000 where it was implicit.

Lowell SSC Guru Points: 323518 More actions · Answer 3

britinusa (10/25/2012)
Did Google this first and it seems some SQL 2005 do not have the Design option.
So one literally has to run an ALTER rather than in 2000 where it was implicit.

yeah that's an important change from 2000; you may remember, it was possible to change the body or a proc/function/view, but then not apply the change by running it...so the saved script was not the same as the compiled version.

forcing you to ALTER or DROP/CREATE prevents that from happening anymore.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!