Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 In which table are the article filters defined?

Author  Topic 

GustiX
Starting Member

28 Posts

Posted - 2011-11-17 : 06:55:04
I am creating a customized replication setup program.
Some of the tables we are replicating (transactional)
have filters. I am looking through the distribution
database and I have found most of what I am looking
for but I can't find a reference anywhere to the
article filter (or the syncobj_ view)

I would expect it to be in the MSarticles system table...

Help!

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-11-17 : 11:03:41
Vertical (column) filters are in sysarticlecolumns in the publisher db.

Horizontal (static row) filters are stored in the sys.sysarticles system view in the distribution db.
Go to Top of Page

GustiX
Starting Member

28 Posts

Posted - 2011-11-17 : 14:24:40
exactly what I was looking for, thanks!
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-11-17 : 15:08:36
You're welcome
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-11-17 : 22:55:08
By the way, if you're creating a custom installation program, may want to have a look at RMO.

Or, in most cases, the script you generated the original setup with can be deployed (with minor modification, or none at all) anywhere. I imagine if you're deploying in many environments that there are environment specific differences you need to query out (server names for example).

In any event, I'd love to see some of what you come up with.

Replication, especially transactional and peer to peer, is one of my favorite features of SQL Server -- something I truly enjoy, a little hobby of mine

I've setup replication on a good number of systems, some local, some geographically dispersed; and have presented on the topic. But always looking to learn something new. Would love to hear more about your project.
Go to Top of Page

victy23
Starting Member

3 Posts

Posted - 2011-12-06 : 04:32:36
I'm new to here.Just to say hello to you.

Love smile,love life.
Go to Top of Page
   

- Advertisement -