SQL Management Studio for SQL Server - User's Manual

1 1999-2015 EMS Database Management Solutions, Management Studio for SQL ServerUser's ManualAll rights reserved. This m anual docum ents EMS SQL Managem ent Studio for SQL ServerNo parts of this work m ay be reproduced in any form or by any m eans - graphic, electronic, or m echanical, includingphotocopying, recording, taping, or inform ation storage and retrieval system s - without the written perm ission of that are referred to in this docum ent m ay be either tradem arks and/or registered tradem arks of therespective owners. The publisher and the author m ake no claim to these tradem every precaution has been taken in the preparation of this docum ent, the publisher and the author assum e noresponsibility for errors or om issions, or for dam ages resulting from the use of inform ation contained in thisdocum ent or from the use of program s and source code that m ay accom pany it.

2 In no event shall the publisher andthe author be liable for any loss of profit or any other com m ercial dam age caused or alleged to have been causeddirectly or indirectly by this docum of this docum entation is subject to the following term s: you m ay create a printed copy of this docum entationsolely for your own personal use. Conversion to other form ats is allowed as long as the actual content is not alteredor edited in any ent generated on: Management Studio for SQL ServerUser's Manual 1999-2015 EMS Database Management Solutions, Management Studio for SQL Server - User's Manual3 1999-2015 EMS Database Management Solutions, of ContentsPart IWelcome to EMS SQL Studio !

3 's new ..8 System requirements ..9 Installation ..11 Registration ..13 How to register SQL Studio ..16 Version history ..18 EMS SQL Studio FAQ Part IIGetting Studio Agent ..38 Selecting application language ..39 First time started ..42 Working with main menu ..44 Working with toolbars ..46 Using Desktop Panel ..48 Using Navigation bar ..50 Using DB Explorer Part IIID atabase Management & Management .. 55 Running SQL Manager .. 55 Using services ..58 Data Manipulation .. 58 Running Data Export .. 59 Running Data Im port .. 60 Running Data Pum p .. 61 Running Data Generator .. 61 Running SQL Script ..63 Data Analysis .. 63 Running Data Com parer .. 64 Running Database Com parer.

4 65 Running DB Extract .. 66 Running SQL Query ..67 Template Management .. 67 Managing existing tem plates .. 68 Creating new tem plates Part IVScheduling & Performing tasks70 SQL Management Studio for SQL Server - User's Manual4 1999-2015 EMS Database Management Solutions, tasks .. 72 Managing tasks and task steps .. 73 Using Task Editor .. 74 Setting notif 76 Using Step tasks .. 78 Managing scheduled tasks .. 80 Using Schedule Editor ..83 Managing logs Part VUsing On-line Internet Resources ..88 SQL Studio Direct ..89 Contacting Support Center Part VISetting program language ..94 Customizing interface ..95 Customizing menus and toolbars ..97 Setting agent options Part templates.

5 100 Supported file formats ..102 Sorting, Grouping, Filtering PartISQL Management Studio for SQL Server - User's Manual6 1999-2015 EMS Database Management Solutions, to EMS SQL Studio !SQL Management Studio for SQL Server is a complete solution for databaseadministration and development. Whether you are a database or application developer,DBA or business analyst, SQL Studio offers all essential tools to make you moreproductive than ever before. SQL Studio unites these tools in one powerful and easy-to-use work Studio provides the must-have tools for administering databases and managingdatabase objects as well as for database migration, comparison and extraction, dataimport, export and our web-site for details: in other languages can be found at: features.

6 Handy launch of utilities and servicesStoring all templates in a single repositoryCommon data source list for all services and utilitiesCreating of complicated branched scriptsAbility to run external applications from scriptsStoring of all script execution logs in one databaseScheduled script executionCreating of customized notifications; various ways to send them outFast access to Technical Support ServiceOne way to customize the appearance for all appsand :All database tasks take little time to launch, leaving you to focus on the resultWith single template repository your work with utilities is as simple as it getsFlexible scripts result in massive time savings, doing all routine jobs for youScript scheduling will automate routine tasksNotification e-mails will let you stay up-to-date and react fastAll logs are stored in one place, putting you totally in charge of all operationsVisual interface style is set uniquely for all products for your convenienceand information:Homepage.

7 TicketSystem: on-lineat: Management Studio for SQL Server - User's Manual7 1999-2015 EMS Database Management Solutions, 's newVersionRelease dateSQL Management Studio for SQL Server 6, 2015 What's new in SQL Management Studio for SQL Server ?Added new services in SQL Management Studio for SQL Server : Check Database,Indices Management , Shrink Database and Update was an issue concerning installation on disks having more than 2Tb of free default folder for logs now points to the User's network notifications (NetSend) did not work on Windows Vista and newer. Studio Agent utilized 100% of CPU when the task generated a large log. Fixed running processes are now stopped correctly when encoding of logs with enabled localization has been of other improvements and also:Version historySQL Management Studio for SQL Server - User's Manual8 1999-2015 EMS Database Management Solutions, requirementsSystem requirements for SQL Management Studio for SQL Server300-megahertz (MHz) processor.

8 600-megahertz (MHz) or faster processorrecommendedMicrosoft Windows NT4 with SP4 or later, microsoft Windows 2000, microsoft Windows 2000 Server , microsoft Windows XP, microsoft Windows 2003 Server , microsoft Windows 2008 Server , microsoft Windows Vista, microsoft Windows Vistax64, microsoft Windows 7, microsoft Windows 7 x64 64MB RAM or more; 128MB or more recommended140MB of available HD space for program installationSuper VGA (800x600) or higher-resolution video adapter and monitor; Super VGA(1024x768) or higher-resolution video adapter and monitor recommendedMicrosoft Mouse or compatible pointing deviceMicrosoft Data Access Components (MDAC) or SQL Server Native ClientPossibility to connect to any local or remote SQL Server SQL Management Studio for SQL Server - User's Manual9 1999-2015 EMS Database Management Solutions, you are installing SQL Studio for the first time on your PC:download the SQL Management Studio for SQL Server distribution package from the download page available at our site;unzip the downloaded file to any local directory, C:\unzipped.

9 Run from the local directory and follow the instructions of the installationwizard;after the installation process is completed, find the SQL Studio shortcut in thecorresponding group of Windows Start you want to upgrade an installed copy of SQL Studio to the latest version:download the SQL Management Studio for SQL Server distribution package from the download page available at our site;unzip the downloaded file to any local directory, C:\unzipped;close SQL Studio application if it is running;run from the local directory and follow the instructions of the the installation process you will be offered to select either to run SQL Studio as anapplication or a as a service, SQL Studio will run independently of the user account currentlylogged in and will use the Windows user account User name and Password specifiedduring the installation process.

10 Note: Use DOMAIN_NAME\USER_NAME format to specify a domain user note that the service should be run under the Windows user account the SQLM anagement Studio for SQL Server application will be Management Studio for SQL Server - User's Manual10 1999-2015 EMS Database Management Solutions, order to install the program in the silent mode as an application you should execute thefollowing /i /quiet order to install the program in the silent mode as a service execute the /i /quiet SERVICE_INSTALL=1 SERVICE_USERNAME="computer_name\user_nam e" SERVICE_PASSWORD="password"Please remember that the User account must be defined with the domain name or thecomputer name, as it is shown in the example above.