Can you log every connection/query run against a db? 1

[Ime532]

I'm curious as to whether or not there is a way to log every connection and query run against the database. If so, could someone give me a brief description on what would be involved? Thanks!

 

[ptheriault]

you would have to run SQL Server profiler.
Profiler is a tool that is installed with the client tools for SQL Server.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Ime532]

Okay thanks!

 

[SQLBill]

Just keep in mind that Profile can be a resource hog and slow down your system.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

Also on a heavy load system you are talking about a LOT of data.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com