RE: error Linked SQL server

#1

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

"Nana" wrote:

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: error Linked SQL server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

RE: error Linked SQL server - 09-12-2009 , 09:11 AM