Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Don't Want to Script Replication Objects

0 views
Skip to first unread message

rmg66

unread,
Dec 14, 2005, 9:41:24 AM12/14/05
to
I have a customized scripting procedure that will script all objects in a
given db.

My problem is, on a db set up for replication, I don't want to script all of
the objects that the system creates to manage replication -- just the
original db objects.

I there way to isolate replication objects?
Are they flagged somewhere in the system as objects that were not actually
created by the user, but by the server system?

Thanks


Hilary Cotter

unread,
Dec 14, 2005, 10:18:52 AM12/14/05
to
The best way is to remove them from the scripting interface. Its a pain to
do.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"rmg66" <rgwathney__xXx__primepro.com> wrote in message
news:%23OkAsxL...@TK2MSFTNGP10.phx.gbl...

Paul Ibison

unread,
Dec 14, 2005, 10:31:03 AM12/14/05
to
You might have to base this largely on the object name prefixes eg
MSmerge_conflict_<PublicationName>_<ArticleName> for the conflict tables. I
mentioned this to Redgate because it becomes a pain there (SQLCompare) also,
but they didn't seem to find an easy solution either.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

rmg66

unread,
Dec 14, 2005, 10:50:47 AM12/14/05
to
What do you mean?
What scripting interface?
How do I remove them without isolating them?


"Hilary Cotter" <hilary...@gmail.com> wrote in message
news:OxPHzGMA...@TK2MSFTNGP10.phx.gbl...

0 new messages