|
|
|
|
Error 7391 when inserting remote sp call results
We replaced our Windows Server 2000 data warehouse (DW) server with a Server
2003 machine. The DW db is in SQL 2000, SP3 (8.00.760). The DW is
populated using remote queries and remote sp calls to the production server.
The latter server is running SQL 7.00.1094.
The DW code can do remote selects, and remote sp calls. It can insert the
results of remove selects into dimension tables. The following works:
insert tblInvoice (InvoiceID, ...)
select InvoiceID, ... from prodsvr.pr
Thu, 13 Jan 2005 12:53:06 -0800
"=?Utf-8?B?a2Fib3JrYQ==?="
|
|