SQL Server Enterprise Manager allows for easy enterprise-wide configuration and management of SQL Server and SQL Server objects. SQL Server Enterprise Manager provides a powerful scheduling engine, administrator alert capability, and a built-in replication management interface.

You can use the Enterprise Manager to:

- Create scripts
- Manage backup devices and databases
- Manage tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types
- Create database diagrams, and database maintenance plans. (To protect performance, full-text searches are not enabled on our system
- Import and export data
- Transform data