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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-01-22 : 05:37:47
|
| Hi,Im running a replication through a subscribed job on sql 2005 but it seems to be giving me an issue and not allowing me to select tables that do not have primary keys to be copied across?Replicating a live transaction database to a database where reporting and intranet is working off.ThanksFahad |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-22 : 07:36:33
|
So what is the question?The replication needs a primary key!Are you able to add a new column (identity)?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-22 : 09:38:47
|
| This depends on type of replication you are doing. |
|
|
|
|
|
|
Replication Jobs