Stored Procedure Editor???

[Don Stuber]

I am about to work with a number of large stored procedures in SQL Server
7.
Does anyone know of a good editor that handles stored procedures nicely?
Preferably one that can highlight or colorize keywords, and indent as appropriate.
An editor that directly accesses the procedure in the database would be ideal,
but I'd happily settle for one that can handle a procedue saved as a script

in an ".sql" file.

Thanks, Don

[Colin McGuigan]

Don Stuber <stuberdo@yahoo.com> wrote in message
news:39d94bda$1@news.devx.com...
>
> I am about to work with a number of large stored procedures in SQL Server
> 7.
> Does anyone know of a good editor that handles stored procedures nicely?
> Preferably one that can highlight or colorize keywords, and indent as
appropriate.
> An editor that directly accesses the procedure in the database would be
ideal,
> but I'd happily settle for one that can handle a procedue saved as a
script
>
> in an ".sql" file.
>
> Thanks, Don

It may not be exactly what you want, but UltraEdit32 (www.ultraedit.com) is
a nice text editor that allows you to define your own syntax highlighting,
and I've set mine up so that it will appropriately highlight SQL scripts.

Won't warn you about syntax errors, and can't connect to the database (it is
just a text editor), but that customizable syntax highlighting is very
useful.

--
Colin McGuigan

[BettyB]

You might also look at Visual Slick Edit (http://www.slickedit.com/). It is
set up recognize PL/SQL but takes only a minute or two to switch it to
T/SQL.

BettyB.

"Colin McGuigan" <colin@chicor.com> wrote in message
news:39d9e3ff@news.devx.com...
> Don Stuber <stuberdo@yahoo.com> wrote in message
> news:39d94bda$1@news.devx.com...
> >
> > I am about to work with a number of large stored procedures in SQL
Server
> > 7.
> > Does anyone know of a good editor that handles stored procedures nicely?
> > Preferably one that can highlight or colorize keywords, and indent as
> appropriate.
> > An editor that directly accesses the procedure in the database would be
> ideal,
> > but I'd happily settle for one that can handle a procedue saved as a
> script
> >
> > in an ".sql" file.
> >
> > Thanks, Don
>
> It may not be exactly what you want, but UltraEdit32 (www.ultraedit.com)
is
> a nice text editor that allows you to define your own syntax highlighting,
> and I've set mine up so that it will appropriately highlight SQL scripts.
>
> Won't warn you about syntax errors, and can't connect to the database (it
is
> just a text editor), but that customizable syntax highlighting is very
> useful.
>
> --
> Colin McGuigan
>
>

[Tonny H]

Why don't just try Visual Interdev????

"BettyB" <bettyb@flamingo-code.com> wrote:
>You might also look at Visual Slick Edit (http://www.slickedit.com/). It
is
>set up recognize PL/SQL but takes only a minute or two to switch it to
>T/SQL.
>
>BettyB.
>
>"Colin McGuigan" <colin@chicor.com> wrote in message
>news:39d9e3ff@news.devx.com...
>> Don Stuber <stuberdo@yahoo.com> wrote in message
>> news:39d94bda$1@news.devx.com...
>> >
>> > I am about to work with a number of large stored procedures in SQL
>Server
>> > 7.
>> > Does anyone know of a good editor that handles stored procedures nicely?
>> > Preferably one that can highlight or colorize keywords, and indent as
>> appropriate.
>> > An editor that directly accesses the procedure in the database would
be
>> ideal,
>> > but I'd happily settle for one that can handle a procedue saved as a
>> script
>> >
>> > in an ".sql" file.
>> >
>> > Thanks, Don
>>
>> It may not be exactly what you want, but UltraEdit32 (www.ultraedit.com)
>is
>> a nice text editor that allows you to define your own syntax highlighting,
>> and I've set mine up so that it will appropriately highlight SQL scripts.
>>
>> Won't warn you about syntax errors, and can't connect to the database
(it
>is
>> just a text editor), but that customizable syntax highlighting is very
>> useful.
>>
>> --
>> Colin McGuigan
>>
>>
>
>
>

[D. Patrick Hoerter]

Don,

> Does anyone know of a good editor that handles stored procedures nicely?
SQL Enterprise Manager? Query Analyzer?

> Preferably one that can highlight or colorize keywords, and indent as
appropriate.
SQL Enterprise Manager? Query Analyzer?

> An editor that directly accesses the procedure in the database would be
ideal,
SQL Enterprise Manager? Query Analyzer?

> but I'd happily settle for one that can handle a procedue saved as a
script
>
> in an ".sql" file.
Query Analyzer?

Is there a reason not to use the built-in tools? They do everything you
asked, with the addition of syntax parsing and estimated execution plan. I
think they're fine products, and best of all, free!

Regards,
D. Patrick Hoerter