SQL server express w/ profiler

http://stackoverflow.com/a/13612052/410622

 

You can activate the SQL Server Express Error Log in a way that it monitors all statements runned agaist every database. To do so you must run the following on an elevated command prompt (that is, a command prompt runned as administrator):

net stop MSSQL$SQLEXPRESS
net start MSSQL$SQLEXPRESS /T4032

Now, using the SQL Server Management Studio run the following:

dbcc traceon(3605, -1)

Now you can look at the ERRORLOG file within the Log folder of MS SQL folder (which may be “C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log” for the default installation of SQL Server Express 2012).

Advertisements