- Business Intelligence with MicroStrategy Cookbook
- Davide Moraschi
- 191字
- 2021-07-23 15:31:57
Installing SQL Server 2012 Command Line Utilities
The command-line utilities are needed to run SQL sentences and scripts onto the database instance. You may feel more comfortable with the full SQL Server Management Studio Express, which is also free to download and use. For simplicity, and not to overload the machine, I will be using only the command line during the recipes.
Getting ready
You need to have completed the previous recipe to continue.
How to do it...
As in the previous recipes, execute the following steps in a command prompt window:
- Install SQL Server 2012 Command Line Utilities by running:
C:\install\SqlCmdLnUtils.msi
- Accept the agreement, allow permission if prompted, and click on Next until the end.
There's more...
Check successful outcome with the following command:
sqlcmd -S (localdb)\v11.0
This should connect to the default instance of SQL Server. It may take a while as the SQL Server instance is loaded on demand, so when you issue this command for the first time, Windows actually has to run the sqlservr.exe
executable. From the second time, the instance will be loaded faster.
- Microsoft Dynamics GP 2016 Cookbook
- Citrix XenApp? 7.5 Desktop Virtualization Solutions
- VMware vCloud Director Essentials
- 企業能源審計與節能規劃
- 注冊會計師全國統一考試專用教材:審計
- 財務建模與綜合估值:數據研磨、模型校準、動態估值
- 中國政府統計問題研究
- 內審人員進階之道:內部審計操作實務與案例解析
- 統計學理論前沿(谷臻小簡·AI導讀版)
- Microsoft SharePoint 2010 Developer’s Compendium:The Best of Packt for Extending SharePoint
- Managing Virtual Infrastructure with Veeam? ONE?
- 審計學
- 內部審計數字化轉型:方法論與實踐
- 審計學
- Citrix Access Gateway VPX 5.04 Essentials