PDA

Click to See Complete Forum and Search --> : Editing Procedures

amarjitamarNew
May 24th, 2005, 04:16 AM
Dear Sir

I am using SQL Server 7. My question is :

Can i edit a procedure that i have created with Create procedure Method.

If it is not possible by using Query Analyser then can anyone tell me any software available for the same.

Thanks in advance

Regards
Amarjit
Klymer
May 24th, 2005, 04:43 AM
yes you can. if you are using query analyzer, just make your object catalogue visible (by pressing F8 or in the menu under extras). then navigate to your sp, right clikc on it and choose "Edit" from the contextmenu

you might as well do it by your own with "ALTER PROC <name> [signature] AS <body>" but QA is easier.
amarjitamarNew
May 24th, 2005, 08:48 AM
Thanks for your reply. But i am unable to follow you. Can you please tell me how. I have pressed F8 nothing happened. I am using SQl query analyser 7.

Regards
Amarjit
Klymer
May 24th, 2005, 11:00 AM
hmmm... okay, i have version 8, so this might not do for you...

but anyway, afaik you should be able to view the object catalogue with qa7 as well. if F8 won't work, try the menu : extras -> object catalogue -> show/hide (i hope i translated correctly as i am using the german version :) ). or look besides the dropdown where your actual database is displayed. two symbols to the right should be a symbol that looks a little bit like a yellow box with some tools bursting out -> that's it!

and then you see your db-objects on the left.


or... one thought.
you don't speak of the EM console, do you? that is where you don't have a sql window but only an overview over your database(s)?
in that case, go to your database, expand it and go to "stored procedures" and open your desired one. you can edit your sp directly there.

hth
amarjitamarNew
May 25th, 2005, 12:53 AM
Thanks for ur reply. But to inform you there is not such thing as "Extra" in my Query Analyser 7 menu still thanks for your cooperation. I will try to edit with EM.

Can u tell me if i download SQL query analyser 8 will it work with SQl Server 7

Thanks
Amarjit