I have setup transactional replication on my PC with SQL 2008 R2, and successfully added some row filters on certain tables. This has worked great.
However, our production server is on SQL 2008 (not R2) and as such I thought I best try it works the same on the older version. Unfortunately the row filtering seems to have had no effect. Can anyone confirm if there was a problem in the previous version
so I know if the production server must be upgraded or if I just have something badly setup.
Thanks for your help.
View Complete Post