Online Documentation for SQL Manager for SQL server
SQL Manager for SQL Server provides a number of powerful tools for working with your database server.
Tools for managing server-level security principals
A convenient tool to browse the server logs
A convenient tool to get information about connections and the locks that they hold
A tool for managing SQL Server workload and resources
SQL Manager for SQL Server provides graphical user interface for most SQL Server objects and native services.
The following tools for SQL Server objects and services management are available in SQL Manager for SQL Server:
Provides a convenient tool to browse the list of recent jobs: Job History.
Provides a powerful tool for working with credentials: Credential Editor.
Provides a powerful tool for working with endpoints: Endpoint Editor.
Provides a powerful tool for working with DDL triggers: DDL Trigger Editor.
Provides a convenient tool for target servers management: Target Servers manager
SQL Manager for SQL Server provides graphical interface for a number of database maintenance operations. The following specific database tools are available in SQL Manager:
Allows you to attach an existing database to the instance of Microsoft® SQL Server™.
Allows you to detach a database from the instance of Microsoft® SQL Server™.
Creates backup copies of entire databases, transaction logs and files/filegroups.
Restores entire databases, transaction logs and files/filegroups from previously created backups.
Reduces data and transaction log files.
Allows you to reorganize, rebuild, and disable indexes.
Updates database statistics.
Checks the allocation, structural, and logical integrity of all database objects.
Allows you to grant/revoke privileges on database objects.
Facilitates using SQL Manager wizards.