Information générale
Forum:
Microsoft SQL Server
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement