error 7390 when isolation level is set to serializable...

• srini_kris

  SSCommitted

  Points: 1738

  More actions

  August 5, 2004 at 2:48 pm

  #86214

  I am trying to replicate the execution of a stored procedure and hence am using isolation level of serializable as recommended by BOL for purge operations.

  This following code works fine when executed on the server ( logging in via terminal services) bu gives me an error when executed thru Query Analyzer.

  Really puzzled.

  ________________________________________________________

  SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

  GO

  begin transaction

  exec dbo.DeleteJobRunResults @SourceSystem = 'GSP Risk Engine',

  @SourceSystemCode =  '13397'

  commit transaction

  go

  _________________________________________________________

  ***************************************************

  Server: Msg 7390, Level 16, State 1, Line 1

  The requested operation could not be performed because the OLE DB provider 'ADSDSOObject' does not support the required transaction interface.

  OLE DB error trace [OLE/DB Provider 'ADSDSOObject' IUnknown::QueryInterface returned 0x80004002].

  *****************************************************

  Any help will be appreciated

  thanks

  -srini

• August 9, 2004 at 8:00 am

  This was removed by the editor as SPAM

• AC Lupu

  Say Hey Kid

  Points: 709

  More actions

  August 11, 2004 at 2:20 am

  #518426

  If you are on Microsoft SQL Server 7.0 have a look at

  Microsoft Knowledge Base Article - 814578

  [814578 - PRB: OLE Automation Error Occurs When SQL Server Runs a Stored Procedure]

  http://support.microsoft.com/default.aspx?scid=kb;en-us;814578