The following table indicates which SQL Enterprise Manager commands can be used to administer SQL Server 6.0 and SQL Server 4.2 servers.
| Menu | Command | 6.0 | 4.2 | Comment |
|---|---|---|---|---|
| File | all commands | X | X | |
| View | all commands | X | X | |
| Server | Register Server | X | X | |
| Server Groups | X | X | ||
| Alerts | X | |||
| Configurations | X | |||
| Replication Options | X | |||
| Current Activity | X | |||
| Error Log | X | |||
| Replication Configuration | X | |||
| Tools | Task Scheduling | X | ||
| Query Analyzer | X | X | ||
| Backup/Restore | X | X | SQL Server 4.2 servers cannot use backup/restore features that are new for SQL Server 6.0. | |
| Set Server/Database | X | X | ||
| Preferences/Configure | X | X | ||
| Manage | Logins | X | X | |
| Devices | X | X | ||
| Databases | X | X | ||
| Replication | X | |||
| Users | X | X | ||
| Groups | X | X | ||
| Tables | X | X | Constraints for declarative referential integrity are not supported for SQL Server 4.2 servers. | |
| Indexes | X | X | ||
| Triggers | X | X | ||
| Stored Procedures | X | X | ||
| Views | X | X | ||
| Rules | X | X | ||
| Defaults | X | X | ||
| User Defined Datatypes | X | X | ||
| Object | Permissions | X | X | REFERENCES permission is not supported for SQL Server 4.2 servers. |
| Dependencies | X | X | ||
| Generate SQL Scripts | X | X | "Table DRI" checkbox is disabled for SQL Server 4.2 servers. | |
| Drop | X | X | ||
| Rename | X | X | ||
| Window | all commands | X | X | |
| Help | all commands | X | X |
Also, the Server States indicators in the Server Manager window will not display for SQL Server 4.2 servers. The Stoplight icon will only display gray (not red, green, or yellow), and the Connect indicator (the red zigzag) will not appear.