Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2014-03-21 : 08:06:57
|
| Hi,I want to store all executed query (from Desktop Application) for a day without profiler in Express edition and store the same in a table or csv.Thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-03-21 : 08:31:30
|
| Profiler/Trace is the tool in SQL Server designated for that purpose. I am not aware of another method to trace all queries on the server.What is your concern about using trace? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-03-21 : 10:50:56
|
Extended events? DML triggers?
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
asm
Posting Yak Master
140 Posts |
Posted - 2014-03-22 : 06:07:07
|
| only want the DML query for selected database but in trace it gives all query for all database |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-03-22 : 09:26:54
|
| You can filter by database and by event types |
|
|
|
|
|
|
DML Query