Automic Workload Automation

  • Private Community

  • 1.  SQL Server 2016 with Automation Engine 12.x

    Posted Oct 19, 2017 03:28 AM
    If you load the initial data and you receive the error:

    U00038042 Enabling Row Versioning-Based Isolation Level.
    U00038284 Row versioning for read-committed and snapshot transactions is disabled.

    Please execute the following statement to solve the issue:
    ALTER DATABASE 'YourDatabaseName'SET READ_COMMITTED_SNAPSHOT ON;
    ALTER DATABASE 'YourDatabaseName'SET ALLOW_SNAPSHOT_ISOLATION ON;


  • 2.  Re: SQL Server 2016 with Automation Engine 12.x

    Posted Oct 18, 2018 10:17 AM

    Die genaue Syntax lautet:

    ALTER DATABASE [YourDatabaseName] SET READ_COMMITTED_SNAPSHOT ON;

    D.h. die Hochkommata durch [] ersetzen, sonst erhält man einen Syntaxfehler.