Find SQL behind a screen

(0) Share

Report

Posted on by roxiejeff1

I am looking for the SQL that runs behind screen TM.TCS.00. Is there any easy way to find this? I know how to grab the SQL from the Crystal Reports within Dynamics but not the .exe screens. Any help?

*This post is locked for comments

All responses (2)

Answers (1)

blmorgan1 60 on at

Like (0)

Report

RE: Find SQL behind a screen

Other than SQL Server Profiler, you can also turn on event logging and check the log that is created as you perform various tasks in the screen. You can find the eventlog files at [install dir]\SL\Applications\EventLog. This log will show the stored procedure or SQL query that runs at each step you take (and you can narrow this down even better if you view with a text editor that allows reloading files when it sees they've been updated). This method isn't perfect, but it is much more focused than SQL server profiler and can often get you what you need to know quickly.
Verified answer

AlexDupuis 314 on at

Like (0)

Report

RE: Find SQL behind a screen

Hi,

The best way I know to find out what it's happening behind SL is SQL Server Profiler. The only problem is that you will receive all SL transactions ;)

If you don't know Profiler, you can find it in SSMS (SQL Server Management Studio) --> Tools --> SQL Server Profiler.

Get a look on that and if you have any questions, just let me know.