|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Error deleting using a temp table and a linked serverWhen I issue this query: DELETE Sqltest001.dtUISQA.dbo.TBL_bill_exceptions_close_ctrl FROM sqltest001.dtUISQA.dbo.TBL_bill_exceptions_close_ctrl D INNER JOIN #TEMP1 ON D.BILLDOCID = src_BILLDOCID IT FAILS WITH THIS ERROR: Server: Msg 7306, Level 16, State 2, Line 1 Could not open table '"dtUISQA"."dbo"."TBL_bill_exceptions_close_ctrl"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements. [OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset::OpenRowset returned 0x80040e21: [PROPID=DBPROP_BOOKMARKS VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetChange VA... IF I ISSUE A DELETE STATEMENT WITHOUT USING A TEMP TABLE IT WORKS. DOES ANY ONE NO HOW TO GET THIS TO WORK WITH THE TEMP TABLE?? THANKS RICH |
|||||||||||||||||||||||