What's the SQL-statement that retreived the data shown on the enduser screen?

(0) Share

Report

Posted on by WillemNAV

Someone must know, I'm not the first. Sure about that :-)

When a enduser looks at his Customer details (for example) in MS-Dynamics-NAV, is it possible to retreive the exact SQL-statement (SELECT * FROM Customer WHERE ....) that retreived the Customer data?

Thanks for your help.

WillemNAV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

Well yes, try to install performance profiler and you can could select that client session and it will show all the SQL statements it generated for that action

ashirokikh.com/.../

Was this reply helpful? Yes No
WillemNAV 5 on at

Like (0)

Report

thanks Suresh, realy helpfull

Was this reply helpful? Yes No