Hi Sergey

on experimenting I can see that on my development server bcp can see tables in any database except System Databases (tempdb,msdb etc).

Could this be a permissions issue ?.

What do you mean by BCP logging ?

and yes the webdata_report table is the same on both servers and is created by the same store procedure.

>Is BCP loging to both SQL Servers the same way?
>Does 'tempdb..webdata_report' table has the same schema on both servers?
>
>
>>Hi I'm using BCP to to copy some data to a csv file.
>>
>>On one server the process works correctly.
>>
>>But on my local development server its failing with the error
>>
>>Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'tempdb..webdata_report'.
>>
>>Any ideas why bcp should work on one serve but not on the other.
>>
>>BTW I do know that tempdb..webdata_report exists on both servers