Home All Groups Group Topic Archive Search About

Error deleting using a temp table and a linked server

Author
26 Aug 2005 5:07 PM
RICH
Help!

When 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

AddThis Social Bookmark Button