Logging User Statistics in SQL Server

[jjpark75]

Hi,

Does SQL Server have tools to track users who are logged onto the SQL Server via a desktop application, as well other pertinent stats? Thanks.

Jung

 

[longneck]

It's called Profiler. We are in the process of decomissioning a coulpe of applications that run off of various SQL Servers, so we set up a computer to run Profiler. It watches all the SQL servers, and writes the activity to a table on one of the SQL Servers.

 

[Vinodk]

You can use profiler to track the users ... You can also query from the backend ...

Select program_name,hostname, nt_username, nt_domain from master..sysprocesses
Where Ltrim(program_name) <>''

You can also use sp_who2 to get the users connected ...

HTH,
Vinod Kumar

 

[jjpark75]

Thanks alot! I'll check out Profiler. I think that may be the answer.

Jung