Searching for comfortable StoredProc Editor. Any recommendations ? 1

[sa5cha]

Hi,

I am Searching for a comfortable Editor for Stored Procedures .

Does anyone has a product recommendation ?
A favorite from experience ?
Or a link which leeds me further ?

Thanky you
Sascha

 

[tlbroadbent]

I prefer Query Analyzer when initially creating a procedure or making major chnages. I'll use Enterprise Manager for minor changes. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[Tim1]

Hi Sascha,

If you want a text editor that you can use, you could try

http://www.textpad.com.

They have a shareware editor, and you can download syntax checkers for various RDBMS systems such as Oralce, Sybase, MS SQL etc. that will highlight keywords etc.

Tim

 

[tlbroadbent]

Query Analyzer color codes reserved words, system stored procedures, comments, literal strings, etc. In addition, you can create the SP and test it in Query Analyzer. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[cdukes]

I personally would never use Query analyser or Enterprise Manager to edit my stored procedures. My Stored procedures are always kept in Ascii text files that I can edit with a standard editor and checked into VSS. My editor of choice would also be Textpad. A very good text editor.

Chris D