[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2003-11-20
6
Medium Priority
?
291 Views
Last Modified: 2007-12-19
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?

Thanks

Scott
0
Comment
Question by:BladesAway
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 70

Expert Comment

by:Scott Pletcher
ID: 9790882
Have you tried Query Analyzer?  It's part of the toolset along with EM.
0
 
LVL 3

Expert Comment

by:htarlow
ID: 9791065
In Visual Studio .NET Architect, you can create database projects.
0
 
LVL 2

Accepted Solution

by:
cetafudd earned 375 total points
ID: 9791801
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 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
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 1

Expert Comment

by:cj_nepenthe
ID: 9791977
Hi,

I use Edit Plus for absolutely everything, it's superb.
http://www.editplus.com/

You can download the SQL syntax highlighting config file from here:
ftp://ftp.editplus.com/files/tsql1.zip

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.
http://www.aquafold.com/

Good luck!
0
 
LVL 8

Expert Comment

by:Dishan Fernando
ID: 9801681
Yes. Use VS.NET . Its really Good
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 9810544
I like Editeur, great (customisable) highlighting, many languages supported
http://www.studioware.com/
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question