October 1, 2003 at 6:02 am
I have a number of 3rd party applications which have user owned tables. I dare not change these to dbo ownership as this may invalidate my support. I have tried all I can to replicate, but don't have access to these tables. I am new to SQL DBM so I am probably missing something obvious. Can you please help? Many Thanks in advance!
Tony Morgan
Fortis Bank UK
London
Tony Morgan
Fortis Bank UK
London
October 1, 2003 at 10:31 am
You shoudn't have any problem even they are not dbo tables.
When creating the publication, in EM, you can specify the tables you wan't to publish and it also shows you the owner.
And if you are creating the publication with a script using stored procedures, the sp sp_addmergearticle/sp_addarticle, has a parameter called source_owner where you must specify the owner of the table.
But if you want you can replicate those table to dbo destination tables.
If you are login with permissions, you shouldn't have problems querying the tables, just do SELECT * FROM UserName.TableName.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply