Online Documentation for SQL Administrator for SQL Server
|
Welcome to EMS SQL Administrator! |
|
What's new |
|
|
Feature Matrix |
|
|
System requirements |
|
|
Installation |
|
|
Purchasing |
|
|
How to register SQL Administrator |
|
|
Version history |
|
|
EMS SQL Administrator FAQ |
|
|
Other EMS Products |
|
|
Getting Started |
|
|
Work area |
|
|
Server Explorer |
|
|
Database Explorer |
|
|
Working with servers |
|
|
Main menu & Toolbars |
|
|
Working with windows |
|
|
Working with grid |
|
|
Filter Builder dialog |
|
|
Servers |
|
|
Register server/Registration properties |
|
|
Configuring general connection settings |
|
|
WMI Connection |
|
|
Managing alarms |
|
|
Setting statistics collection parameters |
|
|
Register servers |
|
|
Alarm summary |
|
|
Alarm Log |
|
|
SQL Administrator Repository |
|
|
WMI Connection |
|
|
Statistics Collector |
|
|
Server properties |
|
|
Memory |
|
|
Processor |
|
|
Parallelism |
|
|
Security |
|
|
Surface area configuration |
|
|
Connections |
|
|
Database options |
|
|
Full-text search |
|
|
Miscellaneous |
|
|
Network |
|
|
Compare server configurations |
|
|
Selecting operation |
|
|
Saving configuration |
|
|
Setting saving configuration options |
|
|
Viewing saving configuration information |
|
|
Executing saving configuration operation |
|
|
Comparing configurations |
|
|
Specifying configurations for comparing |
|
|
Setting comparing configurations options |
|
|
Viewing comparing configurations information |
|
|
Executing comparing operation |
|
|
Viewing comparison results |
|
|
Selecting server to update |
|
|
Specifying destination file name |
|
|
Setting passwords |
|
|
Viewing update information |
|
|
Executing updating operation |
|
|
Deleting configuration |
|
|
Selecting server for deleting configuration |
|
|
Selecting configurations to delete |
|
|
Viewing delele configuration information |
|
|
Executing delete configuration operation |
|
|
Database Maintenance |
|
|
Maintenance plans |
|
|
Maintenance Plan Editor |
|
|
Using Navigation bar |
|
|
Setting general options |
|
|
Managing tasks |
|
|
Backup database |
|
|
Advanced |
|
|
Check database |
|
|
Rebuild indexes |
|
|
Reorganize indexes |
|
|
Shrink database |
|
|
Update statistics |
|
|
Execute job |
|
|
Execute T-SQL statement |
|
|
Notify operator |
|
|
Clean up history |
|
|
Clean up maintenance log |
|
|
Precedence constraints |
|
|
Adding connections |
|
|
Managing schedules |
|
|
Setting reporting options |
|
|
Viewing maintenance plan history |
|
|
Maintenance plan History |
|
|
Backup database |
|
|
Backup Database Wizard |
|
|
Selecting server |
|
|
Setting backup type |
|
|
Selecting a single database to backup |
|
|
Selecting several databases to backup |
|
|
Selecting database files to backup |
|
|
Selecting backup devices |
|
|
Specifying backup sets |
|
|
Setting backup media options |
|
|
Setting backup options |
|
|
Specifying transaction log backup options |
|
|
Setting backup encryption options |
|
|
Setting schedule options |
|
|
Viewing summary information |
|
|
Executing backup database task |
|
|
Backup History |
|
|
Failed backups |
|
|
Backup devices |
|
|
Backup Device Editor |
|
|
Setting general properties |
|
|
Viewing device contents |
|
|
Viewing SQL definition |
|
|
Restore database |
|
|
Selecting server and setting restore type |
|
|
Setting database |
|
|
Specifying point in time |
|
|
Selecting backup set to restore |
|
|
Selecting files and filegroups to restore |
|
|
Setting restore options |
|
|
Setting recovery options |
|
|
Viewing summary information |
|
|
Executing restore database task |
|
|
Attach database |
|
|
Selecting server |
|
|
Defining database files |
|
|
Viewing summary information |
|
|
Executing attach database task |
|
|
Detach database |
|
|
Selecting server |
|
|
Selecting databases |
|
|
Viewing summary information |
|
|
Executing detach database task |
|
|
Check database |
|
|
Check database wizard |
|
|
Selecting server and databases to check |
|
|
Setting schedule options |
|
|
Specifying checks to perform |
|
|
Selecting tables to check |
|
|
Setting repair options |
|
|
Setting check options |
|
|
Viewing summary information |
|
|
Executing check database task |
|
|
Rebuild/Reorganize Indexes |
|
|
Rebuild/Reorganize Indexes Wizard |
|
|
Selecting server and databases |
|
|
Setting schedule options |
|
|
Setting reindex action condition |
|
|
Setting index actions and options |
|
|
Viewing summary information |
|
|
Executing rebuild/reorganize indexes task |
|
|
Shrink database |
|
|
Selecting server and databases |
|
|
Setting shrink type |
|
|
Specifying shrink database options |
|
|
Specifying shrink file options |
|
|
Setting schedule options |
|
|
Viewing summary information |
|
|
Executing shrink database task |
|
|
Database Objects Management |
|
|
Tables |
|
|
Table Editor |
|
|
Using Navigation bar |
|
|
Fields |
|
|
Properties |
|
|
Filetable options |
|
|
Check constraints |
|
|
Indexes and primary/unique keys |
|
|
Statistics |
|
|
Foreign keys |
|
|
Triggers |
|
|
Information |
|
|
Description |
|
|
Permissions |
|
|
SQL definition |
|
|
Field Editor |
|
|
Properties |
|
|
Default value |
|
|
XML options |
|
|
Description |
|
|
SQL definition |
|
|
Check Constraint Editor |
|
|
Properties |
|
|
Description |
|
|
SQL definition |
|
|
Index Editor |
|
|
Properties |
|
|
Storage |
|
|
Filter |
|
|
XML index options |
|
|
Spatial index options |
|
|
Description |
|
|
SQL Definition |
|
|
Statistics Editor |
|
|
Properties |
|
|
Statistics data |
|
|
Density vector |
|
|
Histogram |
|
|
SQL Definition |
|
|
Foreign Key Editor |
|
|
Properties |
|
|
Description |
|
|
SQL Definition |
|
|
Trigger Editor |
|
|
Properties |
|
|
Options |
|
|
Description |
|
|
SQL Definition |
|
|
Views |
|
|
View Editor |
|
|
Properties |
|
|
Fields |
|
|
Indexes |
|
|
Statistics |
|
|
Triggers |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Procedures |
|
|
Procedure Editor |
|
|
Properties |
|
|
Parameters |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Functions |
|
|
Function Editor |
|
|
Properties |
|
|
Parameters |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Data Types |
|
|
Data Type Editor |
|
|
Properties |
|
|
Check constraints |
|
|
Primary/unique keys |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Database Users |
|
|
Database Roles |
|
|
Application Roles |
|
|
Partition Functions |
|
|
Partition Function Editor |
|
|
Properties |
|
|
Description |
|
|
SQL Definition |
|
|
Partition Schemes |
|
|
Partition Scheme Editor |
|
|
Properties |
|
|
Description |
|
|
SQL Definition |
|
|
Sequences |
|
|
Sequence Editor |
|
|
Properties |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Synonyms |
|
|
Synonym Editor |
|
|
Properties |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Schemas |
|
|
Schema Editor |
|
|
Properties |
|
|
Description |
|
|
Permissions |
|
|
SQL Definition |
|
|
Storage |
|
|
Database Editor |
|
|
Using Navigation bar |
|
|
Setting general options |
|
|
Managing filegroups |
|
|
Editing database options |
|
|
Configuring change tracking |
|
|
Viewing database properties |
|
|
Setting permissions |
|
|
Viewing SQL definition |
|
|
Databases |
|
|
Database Snapshots |
|
|
Using Navigation bar |
|
|
Database snapshot editor |
|
|
Viewing SQL definition |
|
|
Disk Space Usage |
|
|
Space Usage by Objects |
|
|
Security |
|
|
Logins |
|
|
Login Editor |
|
|
Using Navigation bar |
|
|
Setting login properties |
|
|
Assigning server roles |
|
|
User mapping |
|
|
Setting permissions |
|
|
Viewing SQL definition |
|
|
Database users |
|
|
User Editor |
|
|
Using Navigation bar |
|
|
Setting database user properties |
|
|
Editing description |
|
|
Setting permissions on user |
|
|
Setting user permissions |
|
|
Viewing SQL definition |
|
|
Database roles |
|
|
Database Role Editor |
|
|
Using Navigation bar |
|
|
Setting database role properties |
|
|
Defining role membership |
|
|
Editing description |
|
|
Setting permissions on role |
|
|
Setting role permissions |
|
|
Viewing SQL definition |
|
|
Application Roles |
|
|
Application Role Editor |
|
|
Using Navigation bar |
|
|
Setting application role properties |
|
|
Editing description |
|
|
Setting permissions on role |
|
|
Setting permissions |
|
|
Viewing SQL definition |
|
|
Server Roles |
|
|
Server Roles Editor |
|
|
Using Navigation bar |
|
|
Setting server role properties |
|
|
Defining server role membership |
|
|
Setting permissions |
|
|
Viewing SQL definition |
|
|
Server Permissions |
|
|
Database Permissions |
|
|
Column permissions |
|
|
Effective permissions |
|
|
Credentials |
|
|
Credential Editor |
|
|
Using Navigation bar |
|
|
Setting credential properties |
|
|
Viewing SQL definition |
|
|
SQL Server Agent |
|
|
Jobs |
|
|
Job Editor |
|
|
Using Navigation bar |
|
|
Setting job properties |
|
|
Managing job steps |
|
|
Managing job schedules |
|
|
Schedule Editor |
|
|
Managing notifications |
|
|
Managing target servers |
|
|
Managing alerts |
|
|
Viewing job history |
|
|
Viewing SQL definition |
|
|
Job history |
|
|
Alerts |
|
|
Alert Editor |
|
|
Using Navigation bar |
|
|
Setting alert properties |
|
|
Setting response |
|
|
Setting advanced properties |
|
|
Viewing SQL definition |
|
|
Operators |
|
|
Operator Editor |
|
|
Using Navigation bar |
|
|
Setting operator properties |
|
|
Managing alert notifications |
|
|
Managing job notifications |
|
|
Viewing notification history |
|
|
Viewing SQL definition |
|
|
Proxies |
|
|
Proxy Editor |
|
|
Using Navigation bar |
|
|
Setting proxy properties |
|
|
Managing principals |
|
|
Managing job steps |
|
|
Viewing SQL definition |
|
|
Credential Editor |
|
|
Performance |
|
|
OS Processes |
|
|
Server Processes |
|
|
Locks |
|
|
Performance Counters |
|
|
Collected Statistics |
|
|
Collected Statistics Trend |
|
|
Index Physical Stats |
|
|
Missing Indexes |
|
|
SQL Server Log |
|
|
Query Editor |
|
|
Using toolbar |
|
|
Working with the Query Editor area |
|
|
Using the context menu |
|
|
Executing queries |
|
|
Using BLOB Editor |
|
|
Editing as Hexadecimal |
|
|
Editing as Text |
|
|
Editing as Rich Text |
|
|
Editing as Image |
|
|
Viewing messages |
|
|
Options |
|
|
Environment |
|
|
Server Explorer |
|
|
Statistics Collector |
|
|
Query tool |
|
|
SQL Editor |
|
|
Highlight |
|
|
Quick code |
|
|
Appearance |
|
|
Appendix |
|
|
Shortcuts |
|
|
Find & Replace text dialog |
|
|
Print preview |
|
|
Database states |
|
|
Select databases dialog |
|
|
Select objects dialog |
|
|
Using templates |
© 2025 EMS Software Development
