Strange DTC problem

• Sher-1032270

  SSC Journeyman

  Points: 93

  More actions

  June 8, 2009 at 1:55 pm

  #155800

  I am encountering a strange problem when querying data from linked server.

  For test purposes I have a linked server to delete data from the same server (SQL Server 2000 SP4). And I get the following error message

  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GatherStats returned 0x80004005: OLE DB provider SQLOLEDB returned 0x80004005 for OpenRowset during statistics gathering].

  I am getting above error only when I used WHERE clause in the query otherwise it works fine when no WHERE clause is used. I checked DTC is well configured and no problem with it. I also have proper login permissions on linked server. What could be the problem? Your help appreciated. Thank you.

• ichayan2003

  Old Hand

  Points: 357

  More actions

  June 22, 2009 at 2:15 am

  #1013158

  Check dbcc traceon (3604) or (7300) is enabled.

  If it is enabled it should be off.

  Thansk