Query Analyzer is pretty good. I also use a text editor called TextPad. Its a great text editor that I use for html and ASP. It allows you to add custom syntax definitions. You can download it from www.textpad.com. You can also download the T-SQL syntax definitions from their page.


>Hi, all..
>
>Are there any decent 3rd party 'add-in' tools for editing SQL Server 2000 stored procs, trigger code, etc.?
>
>The SQL Server 2000 editor is 'OK', and obviously I could just use a good text editor to copy/paste...but was wondering if there was a good 3rd-party tool out there.
>
>Thanks,
>Kevin