Getting information about users that make logon to SQL SERVER

[AMOS]

Hello everybody




I've to write a procedure that retrieves the

login times of a specified user and an indication

if he is in a login status


I would like to know which system's procedures/functions/
views

I can use/query in order to get such information .


This information will help me to process the appropriate

data in my procedure


Thank you

Amos

[Paul G. Tobey [eMVP]]

This group, as you can see by the name, microsoft.public.sqlserver.ce, is
about SQL Compact, not SQL Server. Someone here might know the answer, but
I think you'll get better help if you post to an SQL Server group...

Paul T.

Post by AMOS
Hello everybody
I've to write a procedure that retrieves the
login times of a specified user and an indication
if he is in a login status
I would like to know which system's procedures/functions/
views
I can use/query in order to get such information .
This information will help me to process the appropriate
data in my procedure
Thank you
Amos