TOAD for SQL Server will allow the database administrators and developers (DBAs) to be more productive by providing an intuitive graphical user interface to Microsoft SQL Server 2000 and 7.0 databases.

TOAD for SQL Server is a simple and powerful yet low-overhead Windows client tool that makes SQL development much easier and greatly simplifies database administration tasks.

TOAD for SQL Server provides an advanced browser interface with visual object editors for creates and alters, plus a rich SQL editor with SQL syntax highlighting and robust data grid options. Plus the SQL editor will actually function with any ODBC database connection, thus it supports many other popular databases like Oracle, DB2, Informix, Ingres, Access, MySQL, Sybase, PostgreSQL, etc.

Here are some key features of "TOAD for SQL Server":

· Project Manager
· SQL Editor
· Query Builder
· Report Writer
· Formatter
· Show or Hide, Sort or Filter or Group Columns in tables
· Macro Record
· Difference Viewer ( scripts/files and data)
· Version Control Integration
· ER Diagram
· Master Detail Browser
· HTML Schema Doc Generator
· Convert Embedded SQL
· Grid Compare
· Group Execute
· SQL Trace
· Toad Security
· Website Searching
· One Click Export/ Copy and Paste/ Edit Duplicate Data
· T-SQL Debugger
· Knowledge Xpert for SQL Server
· SQL Optimization
· Automatic Re-Write
· Set Tuning Parameters
· Scans Source Code for Problematic SQL
· Import/ Export Utility Wizard
· External Tools Manager and Connection manager
· Advanced Database Administration
· Compare and Synchronize (Data, Server and Schema)
· Log Reader
· Service Broker Manager
· Job Management and Scheduling
· Add on Modules
· BenchMark Factory
· Toad Data Modeler
· Other
· Online Help Documentation
· World Class Support
· Citrix Installation
· Unparalleled Beta Program


Requirements:

· Platform: 600 MHZ minimum
· Memory: 512 MB of RAM minimum, 768 MB recommended
· Hard Disk Space: 130 MB of disk space for installation.
· (Optional) Spotlight on SQL Server
· Microsoft Internet Explorer 6.0 or later
· Adobe Acrobat Reader 5.0 or later (for viewing the Toad for SQL Server Getting Started Guide)
· Microsoft SQL-DMO 8.0
· Microsoft .NET Framework 2.0 or 3.0



Limitations:

· Some features and options are disabled in the freeware version

What's New in This Release: [ read full changelog ]

· Performance Improvements: major memory improvements for queries that return large result sets in the Editor result sets and the Database Browser Data tab! The memory only increases by a couple of megabytes initially regardless of the size of the result set. Subsequent scrolling of the result set only reads into memory what is needed to display.
· Default window to open when connecting: A separate window no longer prompts you to associate a default window to open when initially connecting to Toad. You now specify the default window to open in the Configuration wizard.
· Editor: View scripts in a full size window ¯ Use docking controls to auto-hide or group the Editor panel, Code Navigator, and result sets. To display the Editor and Results panels in a separate, full size window, drag-and-drop the Results tab into the Editor window.
· Editor: Error line highlighting ¯ Ability to highlight the line in the Editor that caused an execution error. To do this, double-click the error message in the Script Output tab.
· Editor: Change case and add comments ¯ You can now change the case of text or comment or uncomment a line by selecting Editor | Advanced or from the Editor's right-click menu.
· Query Builder: From clause subquery support ¯ You can now add a subquery to a From Clause using the Query Builder toolbar or the right-click menu. A Queries panel displays on the left side of the window with the From Clause subquery. You can add tables and views and create joins the same way you normally use the Query Builder. After creating the subquery, click the parent query in the Queries panel to return to the original query. A From Clause Subquery table now displays in the Diagram panel with all the columns in the subquery. Use this new table as you would any other database object.
· Query Builder: Date ranges ¯ When you add a Where condition for a column that uses a DateTime data type, a new Date Range tab displays in the Where Condition window. The Date Range tab allows you to select a plain text tag such as, “Today,” “Last week,” “Last 30 days,” and “Current year.” The tag you select is added to the Where condition of your query and when executed, is substituted with a BETWEEN command using the appropriate date range. Date Range tags can also be used in the Editor so you can create queries manually. Date Range tags are also useful when executing SQL statements from Automation. You no longer have to edit regularly executed queries to change a date range when you need to retrieve data every month for the previous month.
· Database Administration: Generate SQL drop script ¯ You can now select Drop Script from the Generate SQL right-click menu in the Database Browser or Object Palette.
· Database Administration: Generate SQL retains Formatter settings¯When using the right-click menu to generate SQL in the Database Browser or Object Palette, the settings specified in the Formatter Options pages are now retained.
· Database Administration: Log Reader¯Log Reader server components are now supported on x64 servers and Windows Vista.
· Database Administration: Data Compare provides the ability to: Compare tables and views that have different owners, different names, or different column names, Compare tables that do not have primary keys, Compare specific columns of a table, Change Data Compare project parameters through the Change Data wizard, Connections listed in Data Compare are better integrated with environment in that it now displays connections based on the connections in the Connection Manager.
· Data Management: Grid customization¯You can now customize the grid style when a skin is applied to Toad. You can modify this setting in the Configuration wizard (Tools | Configuration Wizard) or in Interface Options (Tools | Options | Environment | Interface).
· Data Management: Read-only data¯You can now set an option to make all data grids read-only by default.
· Data Management: Search data¯Ability to search data grids for word or phrase matches by pressing CTRL F. Clicking Mark All in the Find window highlights all cells in the grid that match the find criteria.