Online Documentation for SQL Manager for SQL server
Welcome to SQL Manager for SQL Server! |
What's new |
System requirements |
Feature Matrix |
Installation |
Registration |
How to register SQL Manager |
Version history |
EMS SQL Manager FAQ |
Other EMS Products |
Getting Started |
Selecting style and language |
First time started |
Using Desktop Panel |
Database navigation |
Working with database objects |
Using context menus |
Host context menu |
Database context menu |
Object context menu |
Working with windows |
Database Explorer |
Managing database registration info |
Connecting to databases |
Operations with database and server objects |
Selecting multiple objects |
Using tabs for database navigation |
Recently opened objects |
Managing favorite objects |
Searching within the tree |
SQL Assistant |
Configuring Database Explorer |
Managing Favorite queries |
Managing scripts |
Database Management |
Create Database wizard |
Setting database name |
Setting connection properties |
SQL Server Database |
Defining database files |
Defining transaction log files |
Defining files for memory-optimized data |
Defining filestream files and filegroups |
Setting recovery model and collation |
SQL Azure Database |
Setting SQL Azure Database options |
Setting database collation |
Viewing result SQL statement |
Register Database wizard |
Setting connection parameters |
Selecting databases |
Setting specific options |
Database Registration Info |
Connection |
Options |
Display options |
Default directories |
Logs |
Data options |
DDL to Files |
Options for storing object definitions |
Object file names |
Find Option |
Database Properties |
Information |
Options |
Recovery options |
ANSI options |
SQL options |
Automation options |
Cursor options |
FileTable options |
Advanced |
Resource usage |
Data files |
Log files |
Memory-optimized data files |
Filegroups |
Filestream files and filegroups |
Find Option |
Database Registration Manager |
Using Navigation bar and Toolbar |
Server Properties |
General options |
Memory options |
Processor options |
Security options |
Active Directory |
Connection settings |
Database Settings |
Misc Server Settings |
Advanced settings |
Find Option |
Database and Server Objects Management |
New Object |
Duplicate Object Wizard |
Selecting the source database |
Selecting object to duplicate |
Selecting destination database or server |
Modifying the new object's definition |
Database objects |
Schemas |
Schema Editor |
Using Navigation bar and Toolbar |
Creating/editing schema |
Schema Objects |
Tables |
New table |
Using Navigation bar and Toolbar |
Setting table properties |
Specifying columns |
Specifying FileTable options |
Specifying memory-optimized table indices |
Table Editor |
Using Navigation bar and Toolbar |
Managing columns |
Changing columns order |
Managing foreign keys |
Managing checks |
Managing indices |
Managing triggers |
Working with table data |
Table properties |
Columns |
Column Editor |
Setting column name and type |
Setting column identity |
Setting XML properties |
Setting column defaults |
Setting column description |
Foreign Keys |
Foreign Key Editor |
Using Navigation bar and Toolbar |
Creating/editing foreign key |
Checks |
Check Editor |
Using Navigation bar and Toolbar |
Creating/editing check |
Indices |
Index Editor |
Using Navigation bar and Toolbar |
Creating/editing index |
Defining index storage |
Setting spatial index options |
Viewing index info |
Triggers |
Trigger Editor |
Using Navigation bar and Toolbar |
Creating/editing trigger |
Creating procedures from table |
Options |
SELECT Procedure |
INSERT Procedure |
UPDATE procedure |
DELETE Procedure |
Views |
Using Navigation bar and Toolbar |
Creating/editing view |
Managing columns |
Managing indexes |
Managing triggers |
Working with data |
Procedures |
Using Navigation bar and Toolbar |
Creating/editing procedure |
Browsing procedure parameters |
Specifying input parameters |
Executing procedure/function |
UDFs |
Using Navigation bar and Toolbar |
Creating/editing UDF |
Browsing UDF parameters |
UDTs |
Using Navigation bar and Toolbar |
Creating/editing UDT |
Managing UDT checks |
Table Type Check Constraint dialog |
Managing UDT Primary/Unique Keys |
Table Type Constraint dialog |
Sequences |
Using Navigation bar and Toolbar |
Creating/editing sequence |
Synonyms |
Using Navigation bar and Toolbar |
Creating/editing synonym |
Aggregates |
Using Navigation bar and Toolbar |
Creating/editing aggregate |
XML Schema Collections |
Using Navigation bar and Toolbar |
Creating/editing XML Schema Collection |
Defaults |
Using Navigation bar and Toolbar |
Creating/editing default |
Rules |
Using Navigation bar and Toolbar |
Creating/editing rule |
Queues |
Using Navigation bar and Toolbar |
Creating/editing queue |
Viewing queue messages |
External Tables |
Creating/editing external tables |
Non-schema Objects |
Users |
Using Navigation bar and Toolbar |
Creating/editing user |
Defining user membership |
Specifying permissions |
Roles |
Using Navigation bar and Toolbar |
Creating/editing role |
Defining role membership |
Assemblies |
Using Navigation bar and Toolbar |
Creating/editing assembly |
DDL Triggers |
Using Navigation bar and Toolbar |
Creating/editing DDL trigger |
Partition Functions |
Using Navigation bar and Toolbar |
Creating/editing partition function |
Partition Schemes |
Using Navigation bar and Toolbar |
Creating/editing partition scheme |
Full-Text Catalogs |
Using Navigation bar and Toolbar |
Creating/editing full-text catalog |
Managing full-text indexes |
Symmetric Keys |
Using Navigation bar and Toolbar |
Creating/editing symmetric key |
Asymmetric Keys |
Using Navigation bar and Toolbar |
Creating/editing asymmetric key |
Certificates |
Using Navigation bar and Toolbar |
Creating/editing certificate |
Backup Certificate dialog |
Message Types |
Using Navigation bar and Toolbar |
Creating/editing message type |
Contracts |
Using Navigation bar and Toolbar |
Creating/editing contract |
Services |
Using Navigation bar and Toolbar |
Creating/editing service |
Viewing service dialogs |
Routes |
Using Navigation bar and Toolbar |
Creating/editing route |
Remote Service Bindings |
Using Navigation bar and Toolbar |
Creating/editing remote service binding |
DB Scoped Credentials |
Creating/editing db scoped credential |
External Data Sources |
Creating/editing external data source |
External File Formats |
Creating/editing external file format |
Server Objects |
Logins |
Setting login parameters |
Allocating members |
Defining server permissions |
Defining server role permissions |
Defining login permissions |
Defining endpoint permissions |
Defining database permissions |
User mapping |
Backup Devices |
New backup device |
Jobs |
Setting job properties |
Managing job steps |
Managing job schedules |
Managing notifications |
Managing target servers |
Schedules |
Using Navigation bar and Toolbar |
Setting schedule properties |
Viewing scheduled jobs |
Alerts |
Using Navigation bar and Toolbar |
Setting alert properties |
Setting additional properties |
Managing notifications |
Operators |
Using Navigation bar and Toolbar |
Setting operator properties |
Setting additional properties |
Managing alert notifications |
Managing job notifications |
Proxies |
Using Navigation bar and Toolbar |
Setting proxy properties |
Viewing proxy jobs |
Credentials |
Using Navigation bar and Toolbar |
Setting credential properties |
Linked Servers |
Configuring Linked server |
Security settings |
Setting server options |
Linked Server content |
Endpoints |
Using Navigation bar and Toolbar |
Setting endpoint properties |
Setting protocol options |
Setting payload options |
DDL Triggers |
Using Navigation bar and Toolbar |
Setting DDL trigger properties |
Server roles |
Setting server role parameters |
Defining server permissions |
Defining server role permissions |
Defining login permissions |
Defining endpoint permissions |
DTS Packages |
DTS Package properties |
Query Management Tools |
Query Data |
Using Navigation bar and Toolbar |
Working with Query Data area |
Using the context menu |
Viewing query plan |
Using object links |
Executing queries |
Viewing query logs |
Debugging T-SQL |
Favorites editor |
Merging queries |
Design Query |
Using Navigation bar and Toolbar |
Working with diagram area |
Joining two objects |
Setting criteria |
Setting output columns |
Setting grouping criteria |
Setting sorting parameters |
Working with the editor area |
Query execution |
Viewing query plan |
Query parameters |
Input parameters dialog |
Data Management |
Data View |
Using Navigation bar and Toolbars |
Grid View |
Customizing columns |
Grouping and sorting data |
Filtering records |
Using the context menu |
Working in multi-level mode |
Create Grid Level wizard |
Specifying master level |
Defining source for detail level |
Binding master and detail levels |
Query parameterization |
Setting additional parameters |
Working in card view mode |
Column Summary |
Copying records |
Form View |
Print Data |
Page Setup |
Page |
Margins |
Header/Footer |
Scaling |
Report Formatter |
View |
Behaviors |
Formatting |
Styles |
Preview |
Cards |
Charts |
Setting report options |
Print dialog |
BLOB View |
Navigation within BLOB Editor |
Editing as Hexadecimal |
Editing as Text |
Editing as Rich Text |
Editing as Image |
Editing as HTML |
Editing as XML |
Editing as PDF |
Applying changes |
Custom Filter |
Filter Builder dialog |
Invoking the Filter Builder dialog |
Adding a new condition |
Setting filter criteria |
Setting filter operator |
Setting filter criteria values |
Adding a new group |
Setting group operator |
Applying filter conditions |
Data Truncating |
Import/Export Tools |
Export Data Wizard |
Setting destination file name and format |
Selecting columns for export |
Adjusting data formats |
Setting header and footer |
Setting format-specific options |
Excel 97-2003 options |
Data format |
Columns |
Options |
Styles |
Extensions |
Hyperlinks |
Notes |
Charts |
Cells |
Merged Cells |
Advanced |
Access options |
Word 97-2003 / RTF options |
Base Styles |
Strip Styles |
HTML options |
Preview |
Basic |
Multi-file |
Advanced |
PDF options |
TXT options |
CSV options |
XML options |
MS Excel / ODS options |
MS Word / ODT options |
Setting common export options |
Exporting data |
Import Data Wizard |
Selecting source file name and format |
Selecting data source |
Setting columns correspondence |
Excel 97-2003 |
Access/DBF/XML Datapacket |
TXT |
CSV |
HTML |
XML Generic |
MS Excel/Word, ODF |
Adjusting data formats |
Setting advanced column formats |
Setting import mode |
Customizing bulk insert options |
Customizing common options |
Importing data |
Export as SQL Script |
Selecting destination DBMS |
Setting destination file name |
Setting BLOB options |
Selecting columns to export |
Editing table definition |
Setting export options |
Exporting as SQL Script |
Bulk Insert Wizard |
Selecting a table or view and the data file |
Setting bulk insert options |
Customizing data file format |
Viewing the result SQL statement |
Running bulk insert |
Tools |
Dependency Tree |
Using Navigation bar and Toolbar |
Viewing dependency tree |
SQL Monitor |
Using Navigation bar and Toolbar |
Working with SQL Monitor |
Execute Script |
Using Navigation bar and Toolbar |
Working with Execute Script area |
Using Script Explorer |
Script execution |
Extract Database Wizard |
Selecting source database |
Specifying destination file name |
Setting extraction mode |
Setting BLOB options |
Selecting objects for structure extraction |
Selecting server objects for extraction |
Selecting objects for data extraction |
Customizing script options |
Start of extraction process |
Database Comparer Wizard |
Selecting source database |
Selecting target database |
Selecting type of synchronization script |
Defining options for destination script |
Performing operation |
Print Metadata |
Using Navigation bar and Toolbar |
Printing options |
Print Preview |
Search in Metadata |
Using navigation bar and toolbar |
Setting search condition |
Viewing search result |
HTML Report Wizard |
Selecting database and directory |
Selecting object types |
Specifying CSS |
Setting additional report options |
Creating HTML report |
Reports management |
Create Report Wizard |
Specifying database name and report options |
Selecting report bands |
Selecting report style |
Specifying page settings |
Specifying paper settings |
Specifying margins |
Specifying other page settings |
Report Designer |
Basic elements |
Toolbars |
Adding database and query components |
Adding report components |
Viewing the report |
Saving the report |
Adding dialog form |
Report Viewer |
Using Navigation bar and Toolbar |
Server-level principals |
Logins |
Login Manager |
Grant Manager |
Using Navigation bar, Toolbar and context menu |
Managing database-specific privileges |
Object permissions |
Managing column permissions |
Filtering objects in list |
Database permissions |
Viewing effective permissions |
Server Roles |
Database Designer |
Using Navigation bar and Toolbars |
Using Diagram Navigator and DB Objects pane |
Using context menus |
Working with diagram objects |
Adding/removing objects to/from diagram |
Incremental search |
Creating objects |
Creating relations |
Working with diagram pages |
Reverse engineering |
Printing diagram |
Print Preview |
Print Setup dialog |
Saving/loading diagram |
Setting diagram options |
Services |
Backup Database |
Selecting database to backup |
Setting backup type and options |
Selecting database files to backup |
Selecting backup devices |
Setting media options |
Setting advanced media options |
Setting data transfer and/or transaction log backup options |
Setting schedule options |
Running database backup |
Restore Database |
Selecting destination database |
Setting restore type and recovery options |
Selecting backup set to restore |
Selecting files to restore |
Setting advanced restore options |
Running database restore |
Backup Devices |
Backup devices manager |
Backup Device properties |
Attach Database |
Setting connection properties |
Defining database files and general options |
Attaching database |
Detach Database |
Setting connection properties |
Selecting the database |
Detaching database |
Shrink Database |
Selecting database and setting shrink mode |
Defining shrink action for database |
Defining shrink action for files |
Shrinking database |
Indices Management |
Selecting database for indices management |
Selecting tables |
Specifying actions and setting options |
Editing and executing the result script |
Update Statistics |
Selecting database for statistics update |
Selecting tables and views |
Specifying update statistics options |
Browsing indices |
Browsing statistics |
Editing and executing the result script |
Check Database |
Selecting database to check |
Specifying arguments and options |
Editing and executing the result script |
Instance Manager |
Using Navigation bar and Toolbar |
Start/Stop Service |
Configure Service |
SQL Server Agent services |
Jobs |
Jobs manager |
Job History |
Viewing job history |
Filtering job history list |
Alerts |
Alerts manager |
Operators |
Operators manager |
Schedules |
Shared schedules manager |
Proxies |
Proxies manager |
Target Servers |
Target Servers manager |
Database Snapshots |
Managing database snapshots |
Database snapshot properties |
Linked Servers |
Linked servers manager |
DTS Packages |
DTS Packages manager |
Resource Governor |
Using Navigation bar and Toolbar |
Working with Resource Governor |
Server Log Viewer |
Using Navigation bar and Toolbar |
Working with Server Log Viewer |
Activity Monitor |
Using Navigation bar and Toolbar |
Working with Activity Monitor |
Options |
Environment Options |
Preferences |
Full mode activation |
Confirmations |
Appearance |
Tools |
Timeouts |
DB Explorer |
Search |
Object Editors |
Query Data |
SQL Monitor |
Execute Script |
Design Query |
Style & Color Palette |
Default Data Options |
Database Designer |
Print Metadata |
Data Export |
SQL Server Reference |
Fonts |
Grid |
Data Options |
Print Data |
Color & Formats |
Advanced |
Column Options |
Localization |
Global Shortcuts |
Find Option |
Editor Options |
General |
Display |
Color Scheme |
Code Completion |
SQL Formatter |
SQL Words |
Key Mapping |
Spell Checking |
Find Option |
Save Settings |
Specifying destination file |
Selecting settings |
Selecting databases |
Saving settings |
Localization |
Localization Editor |
Select Program Language |
Keyboard Templates |
Object Templates |
Views/Functions/Procedures templates |
SIUD Procedures templates |
Database Object Names |
Column Names |
Foreign Key Names |
Check Names |
Index Names |
Trigger Names |
Server Object Names |
Find Option dialog |
External Tools |
External Tools dialog |
External Tool Info editor |
Appendix |
Program interface |
Viewing object DDL structure |
Editing object description |
Browsing object dependencies |
Setting object permissions |
Changing Metadata window |
Find Text dialog |
Replace Text dialog |
Format specifiers |
Language Info Editor |
Using templates |
Supported file formats |
To-Do List |
Windows List |
Customize toolbars and menus |
SQL Manager Direct |
Database Login dialog |
Overwriting existing output file |
Script conversion |
SQL Server Folders |
Select Object dialog |
SQL Manager shortcuts |
How To... |
Work with Databases |
Connect to a database |
Create a database |
Edit database connection parameters |
Make work with a database faster |
Design a visual database structure |
View an ER diagram |
Backup a database |
Restore a database from a backup |
Create a database copy |
Document a database |
Save metadata reports to file |
Log database changes |
Get an SQL dump |
Reduce database size |
Transfer database from one server to another |
Work with Database Objects |
Group objects |
Find objects |
View dependecies |
Get an object DDL |
Store objects definitions in VCS |
Work with Data |
View tables with many records |
Set data filter |
Sort and group data |
Export/import data |
Export data as SQL Script |
Edit data of master-detail tables |
Add image to table |
Set data display format |
Work with Queries and Scripts |
Create SQL statements rapidly |
Control a query productivity |
Work with several queries at once |
Save most frequently used queries |
Execute queries with parameters |
Export query results into file |
Execute scripts |
Execute a large SQL script |
Make SQL script work faster |
Customize work with Query/Script text |
View executed queries and scripts |
Create a simple report in Report Designer |
Create a scheduled job |
Transfer program settings |
Update SQL Manager |
Report bugs and suggestions |
© 1999-2024 EMS Software Development