Active Directory Query?

MikeDotNetMikeDotNet Posts: 2
edited July 11, 2006 12:32PM in SQL Compare Previous Versions
I have a view that queries Active Directory using a Linked Server on SQL Server 2000. When attempting to synchronize it i get the following error:
[7390] 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].

It's not that big of a deal to me since I only have this one view and I update it manually, but just wanted to throw that out that on the off-chance anything can be done to resolve this.

Thanks,
Mike

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Mike,

    This can happen with linked servers because the driver behind the linked server doesn't support the same isolation level as SQL Server does natively. If you save the script, then change the line

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

    to

    SET TRANSACTION ISOLATION LEVEL READ COMMITTED

    then the script will probably run.
This discussion has been closed.