BCP fails when run from a client system in SQL 7.0greenspun.com : LUSENET : SQL Server Database Administration : One Thread
When I do BCP out from the Server console, it is extracting the data, where as if I run the same command it gives the following error :
SQLState : S1092 [ODBC] [Microsoft SQL Server Driver] Invalid attribute / object identifier.
The syntax what I have used is :
bcp master..sysxlogins out syslogin.out -S
-Uusername -Ppassword -c
COuld you helpme out in this regard
-- Anonymous, October 04, 2001
You need to reinstall MDAC 2.1 (not 2.0) from the SQL Server 7 CD.
Hope this helps,
-- Anonymous, October 09, 2001