Search code examples
sqlsql-serversql-server-2008sql-server-2005bcp

Where we are giving password by using BCP command?

I am pretty much new to bcp but I researched quite a bit and can not find any resource that says where we are actually sending the user name and password to the database with this command. So everyone can access the database?

bcp AdventureWorks2008.HumanResources.Employee out C:\Data\EmployeeData.dat -T
Solution 
  • bcp AdventureWorks2008.HumanResources.Employee out C:\Data\EmployeeData.dat -T -c -U<login_id> -P<password> -S<server_name\instance_name>