Note

This chapter focuses on command-line utilities that are core to SQL Server and the SQL Server database engine. Several other command-line utilities that are used less frequently or geared toward other SQL Server services are not covered in this chapter. These utilities include dtexec and dtutil, which can be used with SQL Server Integration Services (SSIS). Reporting Services has the rs, rsconfig, and rskeymgmt command-line utilities. Lastly, there are several executable files documented as utilities in Books Online (such as ssms, which opens the SQL Server Management Studio) that have limited parameters and are basically used to launch their related applications.

Table 5.1 lists the command-line utilities discussed in this chapter. This ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.