SQL Management Studio for SQL Server - User's Manual

1 1999-2022 EMS Software DevelopmentSQL 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: 24/02/2022 SQL Management Studio for SQL ServerUser's Manual 1999-2022 EMS Software DevelopmentSQL Management Studio for SQL Server - User's Manual3 1999-2022 EMS Software DevelopmentTable 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 ..41 Working with main menu ..43 Working with toolbars ..44 Using Desktop Panel ..46 Using Navigation bar ..48 Using DB Explorer Part IIID atabase Management & Management .. 53 Running SQL Manager .. 53 Using services ..56 Data Manipulation .. 56 Running Data Export .. 57 Running Data Im port .. 58 Running Data Pum p .. 59 Running Data Generator .. 59 Running SQL Script ..61 Data Analysis .. 61 Running Data Com parer .. 62 Running Database Com parer.

4 63 Running DB Extract .. 63 Running SQL Query ..65 Template Management .. 65 Managing existing tem plates .. 66 Creating new tem plates Part IVScheduling & Performing tasks68 SQL Management Studio for SQL Server - User's Manual4 1999-2022 EMS Software tasks .. 70 Managing tasks and task steps .. 71 Using Task Editor .. 72 Setting notif 74 Using Step tasks .. 76 Managing scheduled tasks .. 78 Using Schedule Editor ..81 Managing logs Part VUsing On-line Internet Resources ..86 SQL Studio Direct ..87 Contacting Support Center Part VISetting program language ..92 Customizing interface ..93 Customizing menus and toolbars ..95 Setting agent options Part templates.

5 98 Supported file formats ..100 Sorting, Grouping, Filtering PartISQL Management Studio for SQL Server - User's Manual6 1999-2022 EMS Software Development1 Welcome 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: featuresHandy 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.

6 Various ways to send them outFast access to Technical Support ServiceOne way to customize the appearance for all appsand 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 informationHomepage: TicketSystem: on-lineat: Management Studio for SQL Server - User's Manual7 1999-2022 EMS Software 's newVersionRelease dateSQL Management Studio for SQL Server 6, 2015 What's new in SQL Management Studio for SQL Server ?

7 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-2022 EMS Software requirementsSystem requirements for SQL Management Studio for SQL ServerMicrosoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008,Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft WindowsServer 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Server 2019,Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 , MicrosoftWindows 10, Microsoft Windows 11140MB of available HD space for program installationMicrosoft Data Access Components (MDAC)

8 Or SQL Server Native ClientPossibility to connect to any local or remote SQL Server SQL Management Studio for SQL Server - User's Manual9 1999-2022 EMS Software you are installing SQL Studio for the first time on your PC:download the SQL Studio distribution package from the download page available at oursite;unzip the downloaded file to any local directory, C:\unzipped;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 Studio distribution package from the download page available at oursite;unzip the downloaded file to any local directory, C:\unzipped;close SQL Studio application if it is running.

9 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. 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-2022 EMS Software DevelopmentIn 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.

10 As it is shown in the example above. You can use the ".\user_name"format as also:System requirementsLicense AgreementSQL Management Studio for SQL Server - User's Manual11 1999-2022 EMS Software purchases are provided by Digital River registration service. The Digital River orderprocess is protected via a secure connection and makes on-line ordering by credit/debitcard quick and safe. Digital River is a global e-commerce provider for software and shareware sales via theInternet. It accepts payments in US Dollars, Euros, Pounds Sterling, Japanese Yen,Australian Dollars, Canadian Dollars or Swiss Franks by Credit Card (Visa, MasterCard/EuroCard, American Express, Diners Club), Bank/Wire Transfer, Check or you want to review your order information, or you have questions about ordering orpayments please visit our Customer Care Center, provided by Digital note that all of our products are delivered via ESD (Electronic Software Delivery)only.