July 2, 2009 at 6:38 pm
We are setting up transaction replication. On the database, we have two schemas that I want to replicate. They are called 'Audit' and 'DBO'. The schemas have the same table names. Here's my problem, when I select the tables, it gets the schemas incorrectly. For example, I check audit.customers then I select dbo.customers. When I look at the properties of the dbo.customers, the owner is audit. Has anyone else encountered this? It seems pretty odd. Thank you in advance.
July 3, 2009 at 12:32 am
Hmm, that does seem odd.
What results do you get if you execute the following script on the DB that is to be replicated:-
Select
ss.name As SchemaName,
sdp.name As SchemaOwner
From
sys.schemas ss
Inner Join sys.database_principals sdp
On (sdp.principal_id = ss.principal_id)
Where
ss.name = 'dbo'
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
July 3, 2009 at 8:23 am
Thank you. The result is DBO DBO. It seems pretty odd because on some articles it works well even if there is a duplicate table name in a different schema.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply