Microsoft SQL Server 2008 R2 Unleashed- P16:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 104 CHAPTER 5 SQL Server Command-Line Utilities executable. The location is needed to execute the utility in most cases unless the associated path has been added to the Path environmental variable. TABLE Command-Line Utility Installation Locations Utility Install Location sqlcmd x Program Files Microsoft SQL dta x Program Files Microsoft SQL tablediff x Program Files Microsoft SQL bcp x Program Files Microsoft SQL sqldiag x Program Files Microsoft SQL sqlservr x Program Files Microsoft SQL Server 100 Tools Binn Server 100 Tools Binn Server 100 COM Server 100 Tools Binn Server 100 Tools Binn Server MSSQL Binn NOTE The tablediff utility is installed when SQL Server replication is installed. If you can t find the in the location specified in Table check to see whether the replication was installed. When you are testing many of these utilities it is often easiest to set up a batch file .BAT that contains a command to change the directory to the location shown in Table . After you make this directory change you can enter the command-line utility with the relevant parameters. Finally you should enter a PAUSE command so that you can view the output of the utility in the command prompt window. Following is an example you can use to test the sqlcmd utility which is discussed in more detail later in this chapter CD C Program Files Microsoft SQL Server 100 Tools Binn SQLCMD -S local -E -Q select @@servername pause After you save the commands in a file with a .BAT extension you can simply double-click the file to execute it. This approach is much easier than retyping the commands many times during the testing process. What s New in SQL Server Command-Line Utilities The SQL Server command-line utilities available in SQL Server 2008 are basically the same as those offered with SQL Server 2005. This has some key benefits for those who are familiar with the 2005 utilities. Very little has changed in the syntax and batch files or scripts
