Chapter 5. SQL Server Command-Line Utilities
by Chris Gallelli
IN THIS CHAPTER
BCP
Data Transformation Services Utilities
ISQL/OSQL
makepipe and readpipe
ODBCcmpt
odbcping
rebuildm
regrebld
Replication Utilities
SQLDiag
SQLMaint
SQLServr
VSwitch
This chapter explores the various command-line utilities that ship with SQL Server. These utilities provide administrators with a set of tools for such tasks as automating routine maintenance procedures and verifying client connectivity to SQL Server. In this chapter, you will explore these command-line utilities. For each utility, this chapter provides the command syntax along with the most commonly used options. For the full syntax and options available for the utility, see SQL Server Books Online.
NOTEFour of ... |
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.