NAV2013: Query Design – How To see the –T-SQL

Hi all,

during the Directions I was asked if it is supported to see or change the T-SQL statement which is build by the query.

Unfortunately this is not included in the Query designer. You can see some sample scripts in the readiness material on partner source to have a better understanding for it.

Of course you can also still use the SQL Profiler to analyze the SQL statement but this doesn't matter if you are using a query or any other object type, and you are not able to edit it.

These are steps you have to perform to see the T-SQL for Queries

1. Start the session Windows inside Dynamics NAV 2013 and enable "Start Full SQL Tracing"

2. Start All Programs - Microsoft SQL Server - Performance Tools - SQL Server Profiler