Tables participating in the view reside in different databases which reside on different servers or different instances. GeoPITS brings you the comprehensive details of Distributed partitioned views's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | ||||
| Version v2017 | Yes | ||||
| Version v2016 | Yes | ||||
| Version v2014 | |||||
| Version v2012 | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable |
Tables participating in the view reside in different databases which reside on different servers or different instances
You can find more details about this version here
Back to all features