>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