Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Logging ALL Queries on a SQL Server 2008 Express Database?

Tags:

sql-server

Is there a way to tell SQL Server 2008 Express to log every query (including each and every SELECT Query!) into a file?

It's a Development machine, so the negative side effects of logging Select-Queries are not an issue.

Before someone suggests using the SQL Profiler: This is not available in Express (does anyone know if it's available in the Web Edition?) and i'm looking for a way to log queries even when I am away.

like image 504
Michael Stum Avatar asked Sep 23 '08 20:09

Michael Stum

People also ask

Does SQL Server log queries?

The system doesn't record queries in that way. If you know you want to do that ahead of time though, you can use SQL Profiler to record what is coming in and track queries during the time Profiler is running. Yes, use SQL Profiler, the first option in the SSMS "Tools"-menu.

1 Answers

SQL Server Profiler:

  • File → New Trace
  • The "General" Tab is displayed.
  • Here you can choose "Save to file:" so its logged to a file.
  • View the "Event Selection" Tab
  • Select the items you want to log.
  • TSQL → SQL:BatchStarting will get you sql selects
  • Stored Procedures → RPC:Completed will get you Stored Procedures.

More information from Microsoft: SQL Server 2008 Books Online - Using SQL Server Profiler

Update - SQL Express Edition:

A comment was made that MS SQL Server Profiler is not available for the express edition.
There does appear to be a free alternative: Profiler for Microsoft SQL Server 2005 Express Edition

like image 155
KyleLanser Avatar answered Oct 06 '22 12:10

KyleLanser
Sign in to Comment

Related questions

Count the Number of Tables in a SQL Server Database [duplicate]
T-SQL STOP or ABORT command in SQL Server
be careful parts of your document may include personal information that cannot be removed by the Document Inspector
How to insert multiple records and get the identity value?
How to change the data type of a column without dropping the column with query?
To get total number of columns in a table in sql
identity from sql insert via jdbctemplate
Update Query with INNER JOIN between tables in 2 different databases on 1 server
What is the T-SQL syntax to connect to another SQL Server?
CONCAT'ing NULL fields
Linq to SQL DateTime values are local (Kind=Unspecified) - How do I make it UTC?
Use SQL Server time datatype in C#.NET application?
Remote Procedure call failed with sql server 2008 R2
java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
TRIM is not a recognized built-in function name
SQL Query to add a new column after an existing column in SQL Server 2005
SQL Server: check whether a Trigger is Enabled or Disabled?
How can I catch UniqueKey Violation exceptions with EF6 and SQL Server?
Connecting to MS SQL Server with Windows Authentication using Python?
How to stop SQLServer writing extraneous stuff eg (1 rows affected)

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!