Linked Server Problem

• Vladimir Nickonchuk

  SSC Enthusiast

  Points: 169

  More actions

  August 26, 2004 at 7:13 am

  #108977

  Hi all,

  Really confusing problem with Linked Servers.

  I have two SQL servers in simple environment. On of them production and the second is the archive server.Servers joined  as linked servers. I wrote a couple of stored pocedures for synchronizing. A part of this process is comparing  related tables.  The process has been working for some month, but last time I have got an error:

  OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned 0x80004005:   ]

  I found that every time when quering table with image data type columns it happens.When quering the same table with no image column works fine.

  Already done,

  mdac 2.7 reinstalled; linked server recreated; -g256 startup parameter;

  temp and tmp user variables ; sql sp3 reinstalled

  when run dbcc traceon (7300) the error message was a little bit different

  Server: Msg 7399, Level 16, State 1, Procedure DW_COMPARE_BEFORE_DELETE, Line 67

  OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory.

  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned 0x8007000e:  The provider ran out of memory.]. After that  added -g256 to startup

  

  Thanks

   

   

• August 30, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Alamir

  SSCertifiable

  Points: 6085

  More actions

  September 8, 2004 at 5:54 am

  #522099

  what about incearseing RAM with this server and other server you query ?

  
  Alamir Mohamed
  Alamir_mohamed@yahoo.com