To create view from other database from SQL for Ax database you can get hint by below script. SET QUOTED_IDENTIFIER ON GO Create VIEW [dbo].[TestCustomer] AS SELECT [CUSTGROUP] ,[ACCOUNTNUM] FROM MicrosoftDynamicsAX.dbo.CUSTTABLE group by [CUSTGROUP] ,[ACCOUNTNUM] ; GO Source database is MicrosoftDynamicsAX and destination is testDb in this clip. Just see clip to create view from custtable to other database new view .. Just need to execute script in query editor of SQL. Same way you can include more columns by alter alter THANKS FOR YOUR PATIENT ON WATCHING CLIP.YOU CAN SUBSCRIBE ON MY YOUTUBE CHANNEL TO GET FUTURE UPDATE TO IMPROVE YOUR KNOWLEDGE. GROUP BY IS REQUIRED TO MAKE VIEW READ ONLY. SO ITS IMPORTANT.
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .