Is it possible to log who connects/disconnects and when?

[LucieLastic]

hi All

I'm trying to formulate a matrix of all the processes and applications running in our company that connect & disconnect to the different databases when. Is it possible to log this information somehow?

Many thanks in advance
Lou

 

[djj55]

Look at Profiler / trace. I believe it may help you.



djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[LucieLastic]

Thanks djj55, I'll have a look at it. 'fraid I haven't used the utility much so I was unaware. Thanks again.