Skip to main content

DISABLE_VERSIONING

Short Description

Occurs when SQL Server polls the version transaction manager to see whether the timestamp of the earliest active transaction is later than the timestamp of when the state started changing. If this is this case, all the snapshot transactions that were started before the ALTER DATABASE statement was run have finished. This wait state is used when SQL Server disables versioning by using the ALTER DATABASE statement.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.