SQL Replication Problems

[BCPower001]

I am trying to update a DB on a SQL merge replication subscriber. I get an
error: Invalid object ctsv_A58DF... I know that this is some kind of SQL
replication table but how do I tell ColdFusion to ignore these? I am
connecting to SQL via an ODBC System DSN.

[philh]

Possibly


[url]http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thr[/url]
ead/thread/e8fb8df34a24f8af/d28ccff4f5c43afc?lnk=st&q=update+merge+replication +i
nvalid+object+error&rnum=2&hl=en#d28ccff4f5c43afc

which is not something to ignore.

[BCPower001]

That may be it. I did notice that my subscriber has a lot less SQL Views than
the publisher and a missing view is was threw the error. Are Views supposed to
replicate?

Also, Do I totally reconfigure replication and then generate a script? Is
that what that means? I don't know how to configure replication without using
EM.

Thanks.

[philh]

The publication dictates what's replicated.

Go into EM, expand your publications, and right-click on one. See the
handy-dandy "Generate SQL Script..." option?

Durn near everything in SQL is scriptable. The distribution agents don't have
that option but I bet there's a way around it.