About BCP:
sp_dboption mydb001, "select into / bulkcopy / pllsort", TRUE
Go
To copy the table to the operating system, you must have the right of SELECT to the table below:
1. Table to copy
2.SysObjects
3.syscolumns
4.SysIndexs