>>Can anyone think of a reason that
>>
>>exec master..xp_cmdshell 'bcp "select * from tempdb.dbo.webdata_donation_report" queryout "C:\temp-data\data_file.xls" -c -t\t -T'
>>
>>works ok on one instance of sql server but not on another.
>>
>> the table tempdb.dbo.webdata_donation_report exists on both servers but one server gives an error
>>
>>SQLState = 42S02, NativeError = 208
>>Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'tempdb.dbo.webdata_donation_report'.
>>SQLState = 42000, NativeError = 8180
>>Error = [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
>>NULL
>>
>>the other server finds the data
>>
>>NULL
>>Starting copy...
>>NULL
>>3 rows copied.
>>Network packet size (bytes): 4096
>>Clock Time (ms.) Total : 1 Average : (3000.00 rows per sec.)
>>NULL
>>
>>Thanks
>
>Do you spell the name of the table exactly including casing? Just ruling out possibility of case sensitive collation of tempdb

Hi Naomi

no the case is the same I did check that.

On further investigation on one server none of the tables in tempdb can be accessed by the select. On the other server any tables in tempdb can.