Need a good editor option for Stored Procedure in SQL 2000. The new EM just isn't cutting it.

I haev been working in SQL 7 for years and typically use Enterprise Manager to create/edit by stored procedures.  I recently started working on a SQL 2000.  Using the new version of EM, which is required for SQL 2000, I was suprised to see that the edit/view window for SPs was not sizeable.  I'm not sure if there is a setting somewhere to make it sizeable or not.  If not, I'm wondering what others are using to edit SPs.  I like the highlighting and color in EM, so I'm particular to that --- that is, notepad just won't cut it for me.  I'm looking for something a bit more integrated.  Is there something I can use in Visual Professional?  Any other recommendations?


Who is Participating?
cetafuddConnect With a Mentor Commented:
Hi Blades,

I am using SQL 2000 and like you said I also like to use EM, and yes, it is resizeable (clicking on its border).
If you really can't resize that weird...
Another good option is the query analyser (all new)....try it:
Go to Tools --  Object browser and u have tons of options, some of them very helpful...
I hope that helps...
Scott PletcherSenior DBACommented:
Have you tried Query Analyzer?  It's part of the toolset along with EM.
In Visual Studio .NET Architect, you can create database projects.
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.


I use Edit Plus for absolutely everything, it's superb.

You can download the SQL syntax highlighting config file from here:

It's also possible to set up a macro that will execute your SQL on the server using osql.exe

If that sounds like too much hard work, try Aqua Data Studio.  It's a free alternative to Enterprise Manager and you can even use it to connect to other types of database.

Good luck!
Dishan FernandoSoftware Engineer / DBACommented:
Yes. Use VS.NET . Its really Good
I like Editeur, great (customisable) highlighting, many languages supported
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.