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.

NOTE

Four 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.