O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Horizontal and Vertical Filtering

During the publication creation process, you could have done some filtering of the data, either horizontally or vertically (or both at the same time). The concept of filtering was covered earlier in this chapter. Figure 40.45 illustrates all you need to do to vertically filter (in terms of limiting what gets published to a subset of columns of a table). As you can see, you uncheck the AccountNumber column for the Customer table so that it isn’t included in the article for that object in this publication. This might be done because account number information needs to be more tightly controlled within your company and shouldn’t be part of what is viewed by any subscribing systems.

FIGURE 40.45 Specifying a vertical ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required