AnsweredAssumed Answered

How to create a view from child version without using the stored procedure method? (SQL)

Question asked by mil.parmentieresribelux-esridist Employee on Apr 5, 2018
Latest reply on Jun 20, 2018 by slowe

Hi all,


I am trying to find a way to create a versioned view of a named version (not default version) in SQL server. The feature class is registered as versioned without the option to move edits to base.


In table views within SQL server there are versioned views available from every feature class, but this is the default version. Is it then possible to have a view from the underlying version (child) of default, without using the stored procedures?


I have already asked an Esri Inc Analyst, and he told me there is no other way than using stored procedures to create the versioned view of a specific child version. So here i am, asking the Esri community, maybe someone has found a workaround to this same issue?


Thank you in advance!