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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-07-27 : 11:47:59
|
| at the 'specify articles" on the wizard. Some tables have a key next to it that doesn't let me select them to be replicated. This is happens on transactional replication. But if i do a snapshot, the keys next to the tables are not there.How am I able to select those tables with a key?=============================http://www.sqlserverstudy.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-07-27 : 11:49:09
|
| Do they have a primary key?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-27 : 14:13:36
|
| I dont know about Snapshot replication but for Transactional, you can only replicate tables which have a PK.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-07-27 : 14:42:05
|
| dinakar, no, i cant. transactional won't let me select the tables. It has a key next to it. =============================http://www.sqlserverstudy.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-27 : 15:26:20
|
| Show us the DDL for a couple of the tables that you are having this issue for. Make sure to include all constraints and indexes in the DDL statements.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-07-27 : 22:45:29
|
| im using the wizard to do it.transaction replication doesnt let you replicate table with primary key.=============================http://www.sqlserverstudy.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-27 : 23:41:56
|
| No, transactional replication requires pkey. Double check in table properties page. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-28 : 01:59:38
|
| So you aren't going to post the DDL for your tables, the ones you are trying to replicate but can't?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
transactional replication