Sql trace

whitekid85

i am using the dynamics 4 version with service pak 2

also i has sql 2005 version

Suppose i wrote code like this:

select accountNum from CustTable where custTable.AccountNum == "4000";

As this is a database operation,,
can i see wats happening in the Sql?
if yes, how i can see it.?

Please guide me , i m new on axapta

Harish

Hi,

Usually SQL trace is switched on when there are some performance issues (slow running queries, dead locks etc).

You can switch on SQL trace by switching on SQL trace (under Tools -> Options -> SQL tab).

I hope this helps,