The use_bcp option was by default set to false because bcp did not work through windows authentication. Bcp statement is now modified based on authentication type, with the -T flag used in place of a specified username and password when the connection is through windows authentication. This ensures that the bcp command will use the Windows logged in user's credentials.
The use_bcp option was by default set to false because bcp did not work through windows authentication. Bcp statement is now modified based on authentication type, with the -T flag used in place of a specified username and password when the connection is through windows authentication. This ensures that the bcp command will use the Windows logged in user's credentials.