?
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
?
290 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 69

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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

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.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Suggested Courses

762 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