bcp "select top 7 * from gift..t_data" out "C:\Load\Text1.txt" -T -k -S NTS81B\ISQL01
I got error:
SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. SQLState = 01000, NativeError = 2 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Now I am remotely working on a server (Lets name it as 'GA100F1'), and I have to use a SQL Server (NTS81B\ISQL01). In query analyzer i use NTS81B\ISQL01,1433 to connect. and 'gift' is a database name in this server having table 't_data'
Does 'C:\Load\Text1.txt' this path represent location in the server in which i am remotely logged in. Or some other location ?
Can anyone provie me solution as soon as possible. I am new in SQ server.