Microsoft SQL Server 2000 Administrators Companion

3 4

In this chapter, you have learned how to load the SQL Server database by using BCP, the BULK INSERT statement, and DTS. You've also been introduced to staging tables, which can be useful under some circumstances. And you've learned how to use the SELECT…INTO statement. These utilities and techniques should serve you well because loading the database is a major task for the DBA. In Chapter 25, you'll learn about Distributed Transaction Coordinator and Microsoft Transaction Server.