December 5, 2002 at 7:09 am
I'm new to MS-SQL and have what I hope is a simple question. I have successfully set-up replication of 4 tables. The owner of the source tables is "USERX" but the owner of the tables in the target is 'dbo'. How do I force the target tables to have the proper ownership?
December 5, 2002 at 7:20 am
If you want to change the owner of an object you can use the sp_changeobjectowner store procedure to accomplish this.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 6, 2002 at 3:55 pm
From within the EM wizard, on the dialog where you define the articles, there is a button where you can define the defaults (Lower left hand side). One of the options here is the object owner.
HTH
Steve Hendricks
MCSD, MCDBA
AFS Consulting Group
(949) 588-9800 x15
Steve Hendricks
MCSD, MCDBA
Data Matrix
shendricks@afsconsulting.com
(949) 588-9800 x15
December 7, 2002 at 5:34 am
You'd think it would duplicate whatever owner exists on the publisher, but I guess you'd be wrong as often as right going that way. Another option would be to run a post snapshot script (SQL2K only) that changes the object owner to whatever you need.
Andy
December 7, 2002 at 5:14 pm
Nope MS has to make configurable to please mostly the government but other high end users.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply