General information
Forum:
Microsoft SQL Server
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 ?.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only