Part 3 highlights administrative additions and improvements that are provided with Microsoft SQL Server 6.5, and supplements the information that is presented in the Microsoft SQL Server Administrator's Companion for Microsoft SQL Server 6.0. The following table identifies administrative features as new or enhanced for SQL Server 6.5. Features are in alphabetical order.
| Features | New | Enhanced |
|---|---|---|
| Alerts management interface | · | |
| ANSI to OEM replication | · | |
| Backup and recovery | · | |
| Configurable packet size | · | |
| Connecting to SQL Server over the Internet | · | |
| Custom server configuration using the multiprotocol networking library |
· | |
| Database Backup/Restore dialog box | · | |
| Database Maintenance Plan Wizard | · | |
| Extended stored procedures manager | · | |
| External tools support | · | |
| Fallback support | · | |
| Graph controls | · | |
| Installing SQL Server 6.5 on multiple servers | · | |
| ISQL/w | · | |
| Menus and commands | · | |
| Message management | · | |
| Microsoft Distributed Transaction Coordinator |
· | |
| Microsoft Query | · | |
| Object definitions | · | |
| Point-in-time recovery | · | |
| Print support | · | |
| Remote server registration | · | |
| Remote servers and logins manager | · | |
| Replication | · | |
| Replication and invalid SQL Server names | · | |
| Replication between SQL Server 6.0 and 6.5 | · | |
| Replication for owner-qualified tables | · | |
| Replication log reader | · | |
| Replication to Microsoft Access subscribers |
· | |
| Replication to ODBC subscribers | · | |
| Replication to ORACLE subscribers | · | |
| Replication of text and image data | · | |
| Screen refresh | · | |
| SERVERS.BIN file | · | |
| Server registration information maintenance |
· | |
| SHOWPLAN output | · | |
| AND EXISTS | · | |
| CONSTRAINT | · | |
| EXISTS TABLE | · | |
| FULL OUTER JOIN | · | |
| GROUP BY WITH CUBE | · | |
| LEFT OUTER JOIN | · | |
| NOT EXISTS | · | |
| OR EXISTS | · | |
| SUBQUERY | · | |
| UNION ALL | · | |
| WITH CHECK OPTION | · | |
| SNMP support | · | |
| Specifying columns during replication | · | |
| SQL Enterprise Manager | · | |
| SQL Executive configuration parameters | · | |
| SQL Mail | · | |
| SQL Performance Monitor counters | · | |
| SQL Performance Monitor objects | · | |
| SQL Performance Monitor with integrated security | · | |
| SQL Server Web Assistant | · | |
| SQL Trace | · | |
| SQLExecutiveCmdExec account | · | |
| SQLServer object | · | |
| SQLServer User-defined Counters object | · | |
| SQLServer-Licensing object | · | |
| SQLServer-Lock object | · | |
| SQLServer-Log object | · | |
| SQLServer-Procedure Cache object | · | |
| Stored procedures that support replication to ODBC subscribers |
· | |
| sp_dsninfo | · | |
| sp_enumdsn | · | |
| Table backup and restore | · | |
| Task scheduling interface | · | |
| text and image replication | · | |
| Transaction log point-in-time recovery | · | |
| Transfer management interface | · | |
| Uninstalling replication | · | |
| Wizard and assistant | · |