>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
If it's not broken, fix it until it is.
My Blog