Logging ALL Queries on a SQL Server 2008 Express Database?

by

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

More Related Contents:

  1. The backend version is not supported to design database diagrams or tables
  2. Solutions for INSERT OR UPDATE on SQL Server
  3. sql server 2008 management studio not checking the syntax of my query
  4. How to create multiple one to one’s
  5. T-SQL Cast versus Convert
  6. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  7. How Can I use “Date” Datatype in sql server?
  8. How to replace a string in a SQL Server Table Column
  9. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  10. How to run a stored procedure in sql server every hour?
  11. Splitting the string in sql server
  12. Composite Primary key vs additional “ID” column?
  13. Why do you create a View in a database?
  14. Need to list all triggers in SQL Server database with table name and table’s schema
  15. Saving changes after table edit in SQL Server Management Studio
  16. How do I make a composite key with SQL Server Management Studio?
  17. How can I do a BEFORE UPDATED trigger with sql server?
  18. How to get export output in “real” CSV format in SQL Server Management Studio?
  19. Deferrable Constraints in SQL Server
  20. Know relationships between all the tables of database in SQL Server
  21. Can SQL Server Express LocalDB be connected to remotely?
  22. How do I create and query linked database servers in SQL Server?
  23. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  24. Suggestions for implementing audit tables in SQL Server?
  25. SQL Server search using like while ignoring blank spaces
  26. What does ON [PRIMARY] mean?
  27. How do I list all the columns in a table?
  28. How do I change db schema to dbo
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. Space used by nulls in database

Leave a Comment