YOU WANT TO EXPORT DATA FROM A SQL SERVER INSTANCE TO A TEXT FILE....

1. You want to export data from a SQL Server instance to a text file. This operation

needs to be scheduled to run at night without human intervention. Select the

best option from the following possibilities:

A. Use BCP in a SQL Server Agent Job

B. Use BULK INSERT in a SQL Server Agent Job

C. Use SQLCMD in a SQL Server Agent Job

D. Use OSQL in a SQL Server Agent Job