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
286 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
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 125 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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:dishanf
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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.
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.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

803 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