CODEWITHSUNDEEP
sql-serversql-server-2005system-administration
joe
joe

Reputation: 589

Sql Server 2005 connection log

I have multiple databases on one SQL Server 2005 server. I would like to know a way using which I can see all the connections made to a particular database today and the activities performed.

Thanks in advance

Joe

Upvotes: 2

Views: 1033

Answers (2)

Jack Njiri
Jack Njiri

Reputation: 346

As pointed out by MichealGG, SQL Profiler is a pretty good tool for monitoring connections & events for an instance of SQL Server. Run SQL profiler and start a new trace. You can even filter for specific event classes that you are interested in.

Just be carefull not to leave the trace running indefinitely or for a long time as it takes up a lot of server resources.

Upvotes: 0

MichaelGG
MichaelGG

Reputation: 10006

You can use the SQL Profiler.

Upvotes: 2

Related Questions