How change distribution database compatibility mode from 2005 to 2008

• ico-601891

  Hall of Fame

  Points: 3992

  More actions

  February 22, 2016 at 4:05 am

  #399754

  Hello.

  We have a SQL Server 2008 server with some user databases on it and all of them are defined as SQL Server 2008 compatibility mode. Some of this databases are included in the replication.

  The server is defined as publisher and distributor, and the subscriber is also a SQL Server 2008.

  We see that the distribution database have compatibility mode 2005. We don't know when it was changed. ¿How we can change the distribution database compatibility from 2005 to 2008?

  Thanks.

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  February 23, 2016 at 10:23 am

  #1860492

  ALTER DATABASE [DATABASE] SET COMPATIBILITY_LEVEL = 100