error Linked SQL server

12/09/2009 - 15:27 por Nana | Informe spam
Hi, i'm having problems with two sql servers.

server A = W2003 and SQL2000

server b = W2000 and SQL2000.

both SQL server with SP4

when we run a INSERT in a JOB from B to server A, we get this error:

"Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' could not
INSERT INTO table '[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider
error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error 7312) OLE DB
error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned
0x80040e23: Unknown provider error.]. [SQLSTATE 01000] (Error 7300). The
step failed."

and when we run the SP on Server B we get this:

Server: Msg 7343, Level 16, State 2, Procedure USR_LC_INS_ESTAII_OFI, Line
11
OLE DB provider 'SQLOLEDB' could not INSERT INTO table
'[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown provider error.
[OLE/DB provider returned message: Cursor operation conflict]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow
returned 0x80040e23: Unknown provider error.].


we can do SELECT between server OK.

que puede ser?
 

Leer las respuestas

#1 Erland Sommarskog
12/09/2009 - 16:11 | Informe spam
Nana () writes:
Hi, i'm having problems with two sql servers.

server A = W2003 and SQL2000

server b = W2000 and SQL2000.

both SQL server with SP4

when we run a INSERT in a JOB from B to server A, we get this error:

"Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' could
not INSERT INTO table '[SERVERA].[BASETEST].[DBO].[TABLA]'. Unknown
provider error. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IRowsetChange::InsertRow returned 0x80040e23: Unknown provider error.].
[SQLSTATE 01000] (Error 7300). The step failed."



I did some research, and 0x80040E23 is DB_E_DELETEDROW, but this is
not listed as a possible return code for IRowsetChange::InsertRow. Not
that I think it would have helped much if there had been any information.

Have you tried running the INSERT on Server A instead? Usually when
you get these sort of problems with linked servers, it's better to
think of different ways to achieve what you want than fighting windmills.




Erland Sommarskog, SQL Server MVP,

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sql...14207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sql...95970.aspx
SQL 2000: http://www.microsoft.com/sql/prodin...books.mspx

Preguntas similares