Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Symptoms

After you install SQL Server SP1 Cumulative Update 6 (CU6), SQL Server session hangs indefinitely when you try to enable snapshot isolation by using the following statements:

ALTER DATABASE DatabaseName SET ALLOW_SNAPSHOT_ISOLATION ON

Note This issue may occur when you have a server audit started on the instance which is defined with an audit specification that includes DATABASE_CHANGE_GROUP.

Workaround

To work around this issue, temporarily stop the audit. The following are the statements:

  • Stop the audit: 

    ALTER SERVER AUDIT AuditName  WITH (STATE = OFF) GO

  • Change the database isolation level: 

    ALTER DATABASE DatabaseName SET ALLOW_SNAPSHOT_ISOLATION ON

  • Turn the audit back on: 

    ALTER SERVER AUDIT AuditName WITH (STATE = ON) GO

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminologythat Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×