SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Question to Transactional replication
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

andyhro
Starting Member

Germany
8 Posts

Posted - 05/23/2013 :  08:10:18  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 05/23/2013 :  09:59:02  Show Profile  Visit russell's Homepage  Reply with Quote
This setting really has no effect on Transactional publications. You don't want or need to change it.

Edited by - russell on 05/23/2013 09:59:34
Go to Top of Page

andyhro
Starting Member

Germany
8 Posts

Posted - 05/24/2013 :  03:13:50  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 05/24/2013 :  10:53:19  Show Profile  Visit russell's Homepage  Reply with Quote
If you add an article, generating a snapshot will only snapshot the new article.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000