• Now supports extended Mapi and CDO
• Unicode enabled
• Accepts long parameters
• Works with multiple profiles at once
• Send-from support
• Uses odbc rather than db-lib

Query Analyser

• Mini index tuning in QA removed. Now passes info to full index tuning wizard
• Block indent/comment feature
• Drag and drop scripting of objects from object list to QA window – works with 6.5 format as well (no more extra [‘s)
• Template support. UI to put in values and these used to global change the template
• Client side statistics available – i.e. round-trip time, network trips, network bytes etc.
• Highlight text and hot-key for shortcut queries
• Multi-result set window. Automatically resizes columns for maximum returned values.
• Save results to file (rather than to screen) option. Better performance for large result sets that otherwise will use a lot of virtual memory
• Data edit window – i.e. MS Query replacement
• Script insert/select’s with column lists from object list
• Spid, user, instance name etc. appears in status bar of window
• Version dependent color coding for different SQL versions/sort-orders
• Built-in TSQL debugger (no need for VB/VC EE). Round trip debugging into sp’s, triggers etc.
• Version dependent and case=sensitive color coding for 6.5/7.0/2000.
• Manage indexes – shows index distribution info.

Miscellaneous Tools

• 2000 tools are backward compatible with 7.0. This is an on-going required feature now and will apply to all future releases.
• Debugger inside query analyzer – no need for VB/VC as pre-requisite any more.
• Attach/detach database EM UI added
• Offline database support added to EM UI.
• Column level permissions in EM UI
• Server network utility in EM rather than separate util
• All EM editor dialogs are resizable, however other dialogs are still modal.
• Reworked UI for linked servers and HTML view.
• Client network and server network setup now separate tools and in Enterprise Manager.
• Unicode support in "DaVinci" tools – i.e. table-designer etc.
• Copy database wizard – copy 1:n db’s to another server. Includes logins, sp’s, jobs etc. From 7.0 to 2000 or 2000 to 2000. (can also move). Resolves logins if not present. Also global objects from master, error messages. Uses detach and attach. Doesn’t support 7.0 as target because of collation issues. Name changes not allowed during move. Replicated databases cannot be moved/copied. Log shipped databases cannot be moved. Win9x sources need to create share to access db files manually. Need to be sysadmin member to run. SQL Agent service needs to be running under an NT domain account.
• Much faster load time (700%) with SQL EM.
• Just bug fixes and multi-instance support for SQL Agent.
• Web-Assistant. Just changed to support Unicode and long parameters.

SQL Server 2000 Preview 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19