Tag Archives: SQL

BIDS Development Environment for SQL Server 2012

In order to develop fetch based reports for CRM 2013 you require to have report development environment. You can do this report development on VS (Visual Studio) 2008 using BIDS for Visual Studio 2008. Else, if you have SQL server 2012 installed then you can do report development without installing “BIDS” because SQL 2012 provide… Read More »

Use SQL Tracing to find the SQL query generated for Dynamics CRM Platform Operations for CRM On-Premise

Dynamics CRM works largely on FetchXML queries. FetchXML is a proprietary query language for Dynamics CRM. For developers coming from SQL background, they would really want to find the SQL query that the FetchXML translates into. While one way is to explain the FetchXML syntax, it might help to also get the SQL statement that… Read More »