December 1, 2017 at 8:25 am
I am trying to find out all filters that are applied on my publications. How and can I use sysarticlecolums and sysarticles? Is the artid column that same in both tables
December 1, 2017 at 1:19 pm
myukas - Friday, December 1, 2017 8:25 AMI am trying to find out all filters that are applied on my publications. How and can I use sysarticlecolums and sysarticles? Is the artid column that same in both tables
In 2005, I believe they are both in the distribution database as system views. If you check your version of Books Online for 2005, it will tell you.
sysarticlecolumns just maps each column to the article based on artid. artid does identify the article and is the same in both tables.
sysarticles has a filter column for the stored procedure id if filtered by a stored procedure for foreign key columns and then a filter_clause column and that will have the where clause - what is typically used for filtering. So that is where the filters are.
When you can't find replication things on 2005, look in both the distribution database and the published database and check both system tables as well as system views. The same with tables to views - check both areas as well. Most references or articles will be referring to more recent versions of SQL Server.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply