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
--sb--