EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Services


SQL Manager for SQL Server provides a number of powerful tools for working with your database server.

 

Server-level principals

Tools for managing server-level security principals

 

Server Log Viewer

A convenient tool to browse the server logs

 

Activity Monitor

A convenient tool to get information about connections and the locks that they hold

 

Resource Governor

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:

 

Backup Devices

Provides tools for working with backup devices: Backup devices manager, Backup Device properties.

 

Database Snapshots

Provides tools for working with database snapshots: Snapshots manager, Snapshot properties.

 

Linked Servers

Provides tools for working with linked servers: Linked servers manager, Linked Server Editor.

 

DTS Packages

Provides tools for working with DTS packages: DTS Packages manager, DTS Package properties.

 

Jobs

Provides tools for working with jobs: Jobs manager, Job Editor.

 

Job History

Provides a convenient tool to browse the list of recent jobs: Job History.

 

Alerts

Provides tools for working with alerts: Alerts manager, Alert Editor.

 

Operators

Provides tools for working with operators: Operators manager, Operator Editor.

 

Shared Schedules

Provides tools for working with schedules: Shared schedules manager, Schedule Editor.

 

Proxies

Provides tools for working with proxies: Proxies manager, Proxy Editor.

 

Credentials

Provides a powerful tool for working with credentials: Credential Editor.

 

Endpoints

Provides a powerful tool for working with endpoints: Endpoint Editor.

 

DDL Triggers

Provides a powerful tool for working with DDL triggers: DDL Trigger Editor.

 

Target Servers

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:

 

Attach Database Wizard

Allows you to attach an existing database to the instance of Microsoft® SQL Server™.

 

Detach Database Wizard

Allows you to detach a database from the instance of Microsoft® SQL Server™.

 

Backup Database Wizard

Creates backup copies of entire databases, transaction logs and files/filegroups.

 

Restore Database Wizard

Restores entire databases, transaction logs and files/filegroups from previously created backups.

 

Shrink Database Wizard

Reduces data and transaction log files.

 

Indices Management Wizard

Allows you to reorganize, rebuild, and disable indexes.

 

Statistics Update Wizard

Updates database statistics.

 

Check Database Wizard

Checks the allocation, structural, and logical integrity of all database objects.

 

Grant Manager

Allows you to grant/revoke privileges on database objects.

 

Using templates

Facilitates using SQL Manager wizards.

 

 


See also:

Getting Started

Database Explorer

Database Management

Database Objects Management

Query Management Tools

Data Management

Import/Export Tools

Database Tools

Personalization

External Tools

How To...