Transcription of 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. 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.
2 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 ! '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.
3 61 Data Analysis .. 61 Running Data Com parer .. 62 Running Database Com parer .. 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 ..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.
4 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; 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 ?
5 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) 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.
6 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;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, as it is shown in the example above.
7 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. After purchase you will be able to immediately download the registration keys orpasswords.
8 Also you will receive a copy of registration keys or passwords by email. Pleasemake sure to enter a valid email address in your order. If you have not received the keyswithin 2 hours, please, contact us at To obtain MORE INFORMATION on this product, visit us at distributionDigitalRiverSQL Management Studio for SQL Server (Business license) + 1-YearMaintenance*Buy Now!SQL Management Studio for SQL Server (Business license) + 2-YearMaintenance*SQL Management Studio for SQL Server (Business license) + 3-YearMaintenance*SQL Management Studio for SQL Server (Non-commercial license) + 1-Year Maintenance*SQL Management Studio for SQL Server (Non-commercial license) + 2-Year Maintenance*SQL Management Studio for SQL Server (Non-commercial license) + 3-Year Maintenance*SQL Management Studio for SQL Server (Trial version)DownloadNow!*EMS Maintenance Program provides the following benefits:Free software bug fixes, enhancements, updates and upgrades during themaintenance periodFree unlimited communications with technical staff for the purpose of reportingSoftware failuresFree reasonable number of communications for the purpose of consultation onoperational aspects of the softwareAfter your maintenance expires, you will not be able to update your software or getSQL Management Studio for SQL Server - User's Manual12 1999-2022 EMS Software Developmenttechnical support.
9 To protect your investments and have your software up-to-date, youneed to renew your can easily reinitiate/renew your maintenance with our on-line, speed-throughMaintenance Reinstatement/Renewal Interface. After reinitiating/renewal you will receivea confirmation e-mail with all the necessary also:How to register SQL StudioSQL Management Studio for SQL Server - User's Manual13 1999-2022 EMS Software to register SQL StudioHaving installed SQL Management Studio for SQL Server you will be offered a 30 daysevaluation period. The trial version of the software stays fully functional with some minorfunctional limitations. During all trial period the dialog like displayed below will the trial period is expired, you will not be able to evaluate the software. Furtherusage of your SQL Management Studio for SQL Server copy is only available afterpurchase and can register your copy of SQL Management Studio for SQL Server do it by selectingthe Help | Register SQL Studio main menu item or by selecting the Help | About mainmenu item and pressing the Register Now button to call the Register SQL ManagementStudio for SQL Server Management Studio for SQL Server - User's Manual14 1999-2022 EMS Software DevelopmentTo register your newly purchased copy of EMS SQL Management Studio for SQL Server ,perform the following steps:receive the notification letter from Digital River with the registration info;enter the Registration Name and the Registration Key from this letter;make sure that the registration process has been completed successfully check theregistration information in the About SQL Management Studio for SQL Server dialog(use the Help | About main menu item to open this dialog).
10 The Registration Key you receive includes Maintenance license which is valid during adefinite period. After your maintenance expires you will not be able to update yoursoftware or get technical support. To protect your investments and have your softwareup-to-date, you need to renew your Management Studio for SQL Server - User's Manual15 1999-2022 EMS Software DevelopmentYou can easily reinitiate/renew your maintenance with our on-line, speed-throughMaintenance Reinstatement/Renewal Interface. After reinitiating/Renewal you will receivea confirmation e-mail with all the necessary Management Studio for SQL Server - User's Manual16 1999-2022 EMS Software historyVersionRelease date Version 4, 2008 Version 12, 2007 Version 18, 2006 Full version history is available at Task Scheduler can now be launched as a Windows Service or a separate a custom task is launched manually, its execution process can be tracked in thespecial SSH or HTTP connection type is now displayed within the host name settings used to be reset after the program shutdown.
