error Linked SQL server

[Nana]

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?

[Erland Sommarskog]

Nana (na...@gmail.com) 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, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Linchi Shea]

To help troubleshooting, I'd create a simple test table on A and try to do an
INSERT into that test table from B using the linked server just to see if it
works outside out the proc at all.

Linchi

[Emilio Boucau]

Nana,

No hagas cross-posting y respeta el idioma del foro, por favor.

Saludos !
---
Emilio Boucau
Buenos Aires - Argentina

"Nana" <na...@gmail.com> wrote in message
news:O1opey6M...@TK2MSFTNGP04.phx.gbl...