Online Documentation for SQL Manager for SQL server


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

© 1999-2023 EMS Software Development