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 Studio.net Professional? Any other recommendations?

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 window...wow...thats 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...
Ceta

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server.
First, to frame this stu…

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …

Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.