Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2006-09-19 : 10:18:21
|
| From SQL2005 64bit SP1 to SQL2000 SP3aINSERT INTO [DMZ-SPDV2].[DBA].[dbo].[dba_repsynch_status] ([collect_time],[collect_item]) VALUES ('Jan 1 1900 12:00AM','dba_backup_check')OLE DB provider "SQLNCLI" for linked server "DMZ-SPDV2" returned message "Cursor operation conflict".Msg 7343, Level 16, State 2, Line 1The OLE DB provider "SQLNCLI" for linked server "DMZ-SPDV2" could not INSERT INTO table "[DMZ-SPDV2].[DBA].[dbo].[dba_repsynch_status]". |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2006-09-20 : 08:42:37
|
| Running script on SQL2005 64bit SP1 to a linked SQL2000 32bit SP3a Both servers are WIN2003.INSERT INTO [DMZ-SPDV2].[DBA].[dbo].[dba_repsynch_status] ([collect_time],[collect_item]) VALUES ('Jan 1 1900 12:00AM','dba_backup_check')OLE DB provider "SQLNCLI" for linked server "DMZ-SPDV2" returned message "Cursor operation conflict".Msg 7343, Level 16, State 2, Line 1The OLE DB provider "SQLNCLI" for linked server "DMZ-SPDV2" could not INSERT INTO table "[DMZ-SPDV2].[DBA].[dbo].[dba_repsynch_status]". If I run UPDATE [DMZ-SPDV2].DBA.dbo.dba_repsynch_status SET collect_time='Jan 1 2001 12:00AM' WHERE collect_item='dba_backup_check' I get (0) rows affected and the update does work. Same thing happens with DELETE you get (0) row afftected, but the delete ran. When running a select rowcounts and everything works. I tried using SET XACT_ABORT ON, but the insert still fails. |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2006-09-20 : 09:28:19
|
| Found the problem. On the 2000 server nocount was selected. If I removed nocount from server\properties\connections. The insert worked.My questions id why does everything else work, but insert? |
|
|
|
|
|
|
|
|
Linked Server Error