How do I record SQL transactions with SQL Server Express

Question

With a test migration from 2000 to 2008R2 Express, one function from the client application fails silently. I'd like to find out what SQL is running and why it fails.

I think I would have attacked this with the profiler in 2000 (not sure)? However this tool is absent from the Express Edition.

Is it possible to do what I want without any tool, eg just with T-SQL, and how would I go about it?

gbn · Accepted Answer · 2011-10-12T16:52:54.017

3

You'll need a profiler of some variety if the call is wrapped up.

One of:

Download a trial version, install client tools only
3rd party http://sites.google.com/site/sqlprofiler/

edited Oct 12 '11 at 16:52

answered Oct 12 '11 at 16:33

gbn

70,237
8
167
244

score 3 · Answer 2 · answered Oct 13 '11 at 01:43

I believe that in SQL Server Express, just because you don't have the SQL Server Profiler application you are still able to use the Trace objects.

Please reference this to show an explanation of all the stored procs and functions that you can and need to use: http://msdn.microsoft.com/en-us/library/ms191006.aspx

How do I record SQL transactions with SQL Server Express

2 Answers2