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-04-03 : 12:56:23
|
| 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!" |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2006-04-03 : 16:45:23
|
| Yes you can. In the Publication, after you click on the article that you want, click the "Table Article Properties" box to the right of the article name. It shows you the "source table owner" and you can cut and paste that into the "destination table owner" field. That assumes that the owner exists at the subscriber and has rights to that database. I didn't see a default setting to get around having to enter the owner name once for each table, but I'm no expert, so there could be a better way.I expect that if you already have replication running, then you'd need to reinitialize the subscription & re-snapshot the table, something you might not want to do. It would be easier to just change the owner for the tables at the subscriber. |
 |
|
|
btrimpop
Posting Yak Master
214 Posts |
Posted - 2006-04-04 : 09:40:28
|
| Thanks homebrew. I discovered that option yesterday. You can set the Default owner under the Articles tab which allows you set the subscription owner for all the articles and then go in and manually change the ones that ar different. Kind of a pain in the butt if you have a lot of tables, views, stored procedures that you're replicating with a lot of different owners, but it seems to work.Thanks again"In theory there is no difference between theory and practice. But in practice there is!" |
|
|
|
|
|
|
|
|
Replication Question