Comments
1 comment
-
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.
Add comment
Please sign in to leave a comment.
[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