all groups > sql server replication > december 2005 >
You're in the

sql server replication

group:

Don't Want to Script Replication Objects


RE: Don't Want to Script Replication Objects Paul Ibison
12/14/2005 7:31:03 AM
sql server replication: 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)
Don't Want to Script Replication Objects rmg66
12/14/2005 9:41:24 AM
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

Re: Don't Want to Script Replication Objects Hilary Cotter
12/14/2005 10:18:52 AM
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

[quoted text, click to view]

Re: Don't Want to Script Replication Objects rmg66
12/14/2005 10:50:47 AM
What do you mean?
What scripting interface?
How do I remove them without isolating them?


[quoted text, click to view]

AddThis Social Bookmark Button