Don't Want to Script Replication Objects

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
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:%23OkAsxLAGHA.3924@.TK2MSFTNGP10.phx.gbl...
>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
>
|||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)
|||What do you mean?
What scripting interface?
How do I remove them without isolating them?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxPHzGMAGHA.3924@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> 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:%23OkAsxLAGHA.3924@.TK2MSFTNGP10.phx.gbl...
all[vbcol=seagreen]
actually
>