Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-02 : 11:06:32
|
| Vijay writes "Hi SqlTeam, I have a small query. How to i edit a stored procedure from the query analyzer. Have a nice day.Thanks&RegardsVijay" |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-07-02 : 11:09:03
|
| You right-click on the stored procedure in the object browser list and select Edit.Make the changes and execute.The ALTER PROCEDURE statement will change a store proc |
 |
|
|
Vijaysql
Starting Member
1 Post |
Posted - 2002-07-02 : 12:12:23
|
Hi, Thanks for the information. For a small change in SP, if i would use Alter PRocudure i need to write the entire SP again. Is there any alternative for making small changes to SP apart from editing thru Enterprise Manager.RegardVijayquote:
You right-click on the stored procedure in the object browser list and select Edit.Make the changes and execute.The ALTER PROCEDURE statement will change a store proc
|
|
|
|
dsdeming
479 Posts |
Posted - 2002-07-02 : 13:05:03
|
| The query editing function of Enterprise Manager is not very useful, IMHO. Try editing the query in Query Analyzer instead. It's built to do just that. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-02 : 20:38:12
|
| Do it properly!Keep your stored procedures as separate script files in a source control system. Make ALL your changes to the scripts, run them and check them back in to source control.If you don't, you have no record of who changed what, when it was changed etc. Then one day you think you are pretty smart and you add "With encryption" to your procedure, and it's ALL over. No more source code.Don't belive me ?Do a search of these forums for "unencrypt stored procedure", or "modified date of stored procedure" or any other problems you can think of from people who have not followed good practices with their SQL code.Damian |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-07-02 : 20:46:46
|
| Vijay,From QA:Run... sp_helptext YourProcPaste Results back into the Execution window...Edit away....DavidM"SQL-3 is an abomination.." |
|
|
|
|
|
|
Editing A Stored Procedure