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.
As in the previous recipes, execute the following steps in a command prompt window:
- Install SQL Server 2012 Command Line Utilities by running:
C:installSqlCmdLnUtils.msi - Accept the agreement, allow permission if prompted, and click on Next until the end.
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.