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.
| 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?ThanksAndy----------------------------------------------------- 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. |
 |
|
|
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?ThanksAndy |
|
|
|
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. |
|
|
|
|
|
|
Question to Transactional replication