Good afternoon.
I have encountered an error in BCP that I originally never had. I have
not made any changes to the system, however, the BCP utility fails.
I am running the following statement:
bcp "Select * from Database..View" queryout "C:\Export\infile.txt" -U
user -P Password -f "C:\Formatfile\infile.fmt"
Resulting in the following error:
SQLSTATE = S1010, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver]Function Sequence Error
Background Info:
SQL Server 2000 SP3 (8.00.818)
Thanks!
NathanHi Nathan,
Are other users modifying data when you execute the bcp command ?
If so, then there may be a Deadlock scenario and to over come it, just try
doing an Uncommited read in the BCP command, by adding "with (Nolock)" in
the select statement.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
没有评论:
发表评论