sql server replication: Hi,

I created a new table on the publication database the owner of the new table
is not dbo. We then called sp_addmergearticle to add the article to the
publication, using the @source_owner and @destination_owner parameters to
specify the owner is different from dbo, and the @force_invalidate_snapshot
parameter.

When we start the snapshot agent, it prepares the newly added table for
replication, and generates the necessary scripts. At one moment the snapshot
agent stops with an error stating 'invalid object name' and the name of the
new table. I think this occurs when the snapshot agent wants tot generate
the bcp files.

Inspecting the article's properties dialog, showed 'that source table owner'
and 'destination table owner' are correct. And except for the tablename an
article name the properties are no different to the previously published
articles.

I retried this for a table that has dbo as owner. This worked without
problems.

Does anybody experienced the same problems?

Best regards,

Stefan

Just some more info. It seems like the problem occurs when the snapshotagent
generates the bulk copy data for system table
ms_merge_contents_<<newtable>>. It seems like this procedure doesn't use the
right owner to generate the bcp file.

Stefan

"Stefan Gevaert" <stefan.gevaert@omegasoft.be> schreef in bericht
news:%23dRgpbFBFHA.3120@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

Thanks Kestutis,

I looked for your posts but I didn't find them. Could you repost them?

regards,

Stefan
"Kestutis Adomavicius" <kicker.lt@nospaamm_tut.by> schreef in bericht
news:ORM4krGBFHA.1400@TK2MSFTNGP11.phx.gbl...
I had multiple problems with merge replication of objects not owned by dbo.

And I made multiple posts to this newsgroup with a solution - fixes to bugs
in merge replication system stored procedures. Try looking for my messages
(end of last year) - you should find attached archive with those fixes. if
you will not find it, I could re-post it in this thread (I have fixes for
SQL server versions 8.00.760 (SP3a) and 8.00.818)

--
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"


[quoted text, click to view]
Hi,

I created a new table on the publication database the owner of the new table
is not dbo. We then called sp_addmergearticle to add the article to the
publication, using the @source_owner and @destination_owner parameters to
specify the owner is different from dbo, and the @force_invalidate_snapshot
parameter.

When we start the snapshot agent, it prepares the newly added table for
replication, and generates the necessary scripts. At one moment the snapshot
agent stops with an error stating 'invalid object name' and the name of the
new table. I think this occurs when the snapshot agent wants tot generate
the bcp files.

Inspecting the article's properties dialog, showed 'that source table owner'
and 'destination table owner' are correct. And except for the tablename an
article name the properties are no different to the previously published
articles.

I retried this for a table that has dbo as owner. This worked without
problems.

Does anybody experienced the same problems?

Best regards,

Stefan

I had multiple problems with merge replication of objects not owned by =
dbo.

And I made multiple posts to this newsgroup with a solution - fixes to =
bugs in merge replication system stored procedures. Try looking for my =
messages (end of last year) - you should find attached archive with =
those fixes. if you will not find it, I could re-post it in this thread =
(I have fixes for SQL server versions 8.00.760 (SP3a) and 8.00.818)

--=20
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"


[quoted text, click to view]
Hi,

I created a new table on the publication database the owner of the new =
table=20
is not dbo. We then called sp_addmergearticle to add the article to =
the=20
publication, using the @source_owner and @destination_owner parameters =
to=20
specify the owner is different from dbo, and the =
@force_invalidate_snapshot=20
parameter.

When we start the snapshot agent, it prepares the newly added table =
for=20
replication, and generates the necessary scripts. At one moment the =
snapshot=20
agent stops with an error stating 'invalid object name' and the name =
of the=20
new table. I think this occurs when the snapshot agent wants tot =
generate=20
the bcp files.

Inspecting the article's properties dialog, showed 'that source table =
owner'=20
and 'destination table owner' are correct. And except for the =
tablename an=20
article name the properties are no different to the previously =
published=20
articles.

I retried this for a table that has dbo as owner. This worked without=20
problems.

Does anybody experienced the same problems?

Best regards,