MS SQL Server - Tracing SQL Server Mobile

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Tracing SQL Server Mobile - is it possible?

master

2006-10-24, 6:38 pm

(trying again)

Is it possible to trace the SQL Server Mobile queries? I could not google
anything about it :-(.

Yes... you can enable 'logging' in SQL Mobile Query Analyser but...
- I could not find out where the log was actually created...
- I do not know, if only the events from within the Query Analyser are
recorded, or maybe from external programs, too...
- as far as I know, query strings are not recorded...

I am interested in learning what query string is sent to a mobile database
in a speciffic situation. It is perfectly OK if I find it out by an offline
checking, I do not need an on-the-fly, runtime trace in a strict sense...
well... do the mobile databases have transaction logs? Can they be analysed?

DW

Sponsored Links