Groups | Blog | Home
all groups > sql server replication > february 2007 >

sql server replication : Transactional replication into existing (non dbo) tables


Anis
2/26/2007 1:03:18 PM
Hi

I am trying to setup a transactioal replication from 2 servers to 2.
I already have a table that has an owner that is not dbo (lets say user1)
Whenever i setup the replication if i tell it to create schema and data, it
create dbo.table on the detsination. If i chose to not create (the
destination has data and schema) it fails with missing stored procedure.
In one instance when i told it to create schema, it game me an error saying
the table does not exist (when the user1.table actually existed)

I know this can be done, i just can not figure out how, help?
Anis
2/27/2007 11:39:18 AM
That problem is resolved, I figured it out, it was pretty simple actually.
However i am running into other issues that i am going to create a different
post for.


[quoted text, click to view]
AddThis Social Bookmark Button