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 |
|
btrimpop
Posting Yak Master
214 Posts |
 Posted - 2006-03-31 : 17:03:34
|
| Hi All,Can someone tell me what/if I'm doing something wrong. I'm trying to set up Transactional Replication using SQL 2000 w/ latest service packs.Everything goes ok until...The tables in the published database have owners like ar, cd, and so forth. The tables in the subscription database are ending up with dbo as the owner. Is there someway to replicate a database so the orginal owners are still the owners in the replicated database? What am I missing?Thanks"In theory there is no difference between theory and practice. But in practice there is!" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-03 : 03:08:39
|
not sure if this is still of any use to you...in the article properties on your publisher's side, there is an option for the snapshot generation, and you can define who will be the owner in the subscriber --------------------keeping it simple... |
 |
|
|
|
|
|
Replication question