Need a good editor option for Stored Procedure in SQL 2000. The new EM just isn't cutting it.
Posted on 2003-11-20
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?