title: Saving an SQL Server view to the Dynamics AX AOT
body: <p>I have found there are significant advantages to writing views in SQL Server Management Studio rather than creating them in the AOT. However, it appears that</p>
  
  <ul>
  <li>Views created in SQL Server are not accessible from X++ code and do not appear in the AOT.</li>
  <li>Views created in the AOT and then modified in SQL Server Management studio can be accessed from X++ code but are overwritten when the AOT view is recompiled or synchronized.</li>
  </ul>
  
  <p>Is there any way around this problem? Ideally SQL views could be reengineered to be saved in the AOT, but this doesn't appear to be possible. </p>