Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Question to Transactional replication

Author  Topic 

andyhro
Starting Member

8 Posts

Posted - 2013-05-23 : 08:10:18
All my databases in SQL Server 2008 R2 are set to COMPATIBILITY_LEVEL = 100 (Select cmptlevel from sysdatabases).
The Procedure sp_helppublication returns the backward_comp_level.
I get on my SQL Server 2008 R2 (for all transactional replication) the result: backward_comp_level = 40 (SQL Server 2000).

Why is that?
When creating a Publcation I have no influence?!
How can I change the backward_comp_level?

Thanks
Andy

-----------------------------------------------------


backward_comp_level
===================
10 = Microsoft SQL Server 7.0
40 = Microsoft SQL Server 2000
50 = SQL Server 2000 Service Pack 1
60 = SQL Server 2000 Service Pack 3
90 = Microsoft SQL Server 2005
100 = Microsoft SQL Server 2008

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-05-23 : 09:59:02
This setting really has no effect on Transactional publications. You don't want or need to change it.
Go to Top of Page

andyhro
Starting Member

8 Posts

Posted - 2013-05-24 : 03:13:50
Thank you first.
I have another question:

I add 1 article to a Publication.
When it's possible create a snapshot with only one table? (no complete init with all tables)
Under what preconditions is possible?

Thanks
Andy
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-05-24 : 10:53:19
If you add an article, generating a snapshot will only snapshot the new article.

Go to Top of Page
   

- Advertisement -