Verifying the Compatibility Level of Microsoft SQL Server

Verify that the database compatibility level is set to Microsoft SQL Server 2005 (90) or Microsoft SQL Server 2008 (100).

Replication Agent supports Microsoft SQL Server 2005 Service Pack 2 and Microsoft SQL Server 2008. To verify the compatibility level:

  1. In the Microsoft SQL Server Management Studio, right-click your primary database and select Properties.
  2. In Database Properties, click Options, and verify that the Compatibility level is "Microsoft SQL Server 2005 (90)" or "Microsoft SQL Server 2008 (100)." If it is not, select that compatibility from the drop-down list, and click OK.
Parent topic: Primary Microsoft SQL Server Configuration and Verification