By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

Log all connections to a SQL Server

P: n/a
I need to log all users connecting to any database on my SQL Server 2000
cluster.

Anyone know how I can accomplish this ?

Ta,

CJ.

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi

Some options:

On the security tab for the server you can set login auditing.
You can also set C2 auditing on for more information.
You can use profiler to log these events.
You can use a third party tool.

John
"Chris Sleightholme" <sl**********@ntlworld.com> wrote in message
news:r7***************@newsfe2-win.ntli.net...
I need to log all users connecting to any database on my SQL Server 2000
cluster.

Anyone know how I can accomplish this ?

Ta,

CJ.

Jul 23 '05 #2

P: n/a
Try this in Query Analyzer,
use master
go
Select * from sysprocesses

This should give you all the fields you need.

Oscar...
"Chris Sleightholme" <sl**********@ntlworld.com> wrote in message
news:r7***************@newsfe2-win.ntli.net...
I need to log all users connecting to any database on my SQL Server 2000
cluster.

Anyone know how I can accomplish this ?

Ta,

CJ.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.