SQL SERVER Interview Questions-part8



  1. What is BCP? When do we use it?
    BulkCopy is a tool used to copy huge amount of data from tables and views. But it won’t copy the structures of the same.
  2. What should we do to copy the tables, schema and views from one SQL Server to another?
    We have to write some DTS packages for it. 
Labels: ,