Mike,
I really like the SQL Query Analyzer that ships with MSSQL Server 2000,
but some of my group has started to use mssqlXpress (
www.xpressapps.com),
since we are many times working with very large databases. This tool's
biggest feature is it's version control, but it also does things like:
- group objects in folders to make it easier to find
- search for text throughout all objects (nice for finding everywhere a
table is accessed, for example)
- pick table, field and variable names from an Intellisense-like list as you
type code
Also, if you are new to SQL Server, you might check out our SQL Server 2000
videos at
http://www.TechnicalVideos.net. They include lots of info on
tuning and performance as well as many other SQL Server 2000 topics. We
also have ASP.NET and Flash MX 2002 videos.
Hope this helps,
Chuck Conover
www.TechnicalVideos.net
"Ixnay" <ms******@yahoo.com> wrote in message
news:21**************************@posting.google.c om...
Hi All,
I am new this week to sql*server / query analyzer, coming from years
of an oracle / TOAD background. Does anyone have any tools they
prefer for writing and executing sql code other than query analyzer?
Thanks!
Mike