Hi,

Does anyone have a list of or recommendation for tools to use in T-SQL/SQL7/2000 development? Currently, our arsenal consists of Enterprise Manager and Query Analyzer. I am looking at BMC SQL Programmer and a product called OpenSoft SQL Studio. Any comments on these or other products. My main interests are:

- better T-SQL/SQL IDE/Editor than Query Analyzer
- T-SQL debugger
- Script generation/management (i.e. for updates sent to sites)

I am also looking for a good and preferably not overly inexpensive CASE/data modeling tool. I understand I may want a separate tool for this.

TIA,