sql profiler: log user logins

[aspijker]

Dear colleques,

I need to report about how many users login, for how long (average), maximum time and minimum of period logged on, from which application and how many failed logon attempts.

Can you help me make a trace template for sql profiler?

Thanks!

Salsa

 

[ptheriault]

Take a look here. It will walk you through
creating a trace template.

http://www.sqlservercentral.com/columnists/bkelley/auditingwithsqlprofiler.asp

- Paul

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