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.


UPDATE

on experimenting I can see that on my development server bcp can see tables in any database except System Databases.

Could this be a permissions issue ?.