How to find out when a user last logged in

Hi There

I am in the process of cosolidating sql servers.

One of them literally has hundreds of sql logins, obviously i need to clean these up, however i a not sure how to determine when a user last logged in ?

How can i find out the last login date of a user ?

Thanx

Hi,

AFAIK this is not stored in tables in SQL Server, but it is either stored in

1. The event log if you turned on the Audit feature in the server properties.
2. In the c2 audit logs (if turned on)
3. In the profiler trace (if you are running one and are wathing the Audit events on the server)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Oh man that is bad news i guess, i could spend days sifting through the event logs, and even then i wont be sure a login is not used, for example if someone simply has not logged in this week.

Thanx Anyway

How to find logged errors and not-logged erros

Alert don't fire if error is not logged.
How to find logged errors and not-logged erros '
Errors in severity level 20 to 25 are always logged?
ThanksFor logged errors, look in the application log and the SQL
Server error log. Messages that aren't logged you won't find
anywhere. They aren't logged so they aren't recorded
anywhere.
Fatal severity level errors (20 -25), are logged in the
error log and the application log.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:
>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||And one other thing to add...they are stored in the
sysmessages table in master. The dlevel indicates if they
are logged or not.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:
>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||Wich is the value for logged error?
Is 128 ?
Thanks
"Sue Hoegemeier" wrote:
> And one other thing to add...they are stored in the
> sysmessages table in master. The dlevel indicates if they
> are logged or not.
> -Sue
> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
> favero@.discussions.microsoft.com> wrote:
> >Alert don't fire if error is not logged.
> >How to find logged errors and not-logged erros '
> >Errors in severity level 20 to 25 are always logged?
> >
> >Thanks
>|||Yup...128 is logged.
-Sue
On Wed, 16 Mar 2005 07:17:04 -0800, "andrea favero"
<andreafavero@.discussions.microsoft.com> wrote:
>Wich is the value for logged error?
>Is 128 ?
>Thanks
>"Sue Hoegemeier" wrote:
>> And one other thing to add...they are stored in the
>> sysmessages table in master. The dlevel indicates if they
>> are logged or not.
>> -Sue
>> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
>> favero@.discussions.microsoft.com> wrote:
>> >Alert don't fire if error is not logged.
>> >How to find logged errors and not-logged erros '
>> >Errors in severity level 20 to 25 are always logged?
>> >
>> >Thanks
>>

How to find logged errors and not-logged erros

Alert don't fire if error is not logged.
How to find logged errors and not-logged erros ?
Errors in severity level 20 to 25 are always logged?
Thanks
For logged errors, look in the application log and the SQL
Server error log. Messages that aren't logged you won't find
anywhere. They aren't logged so they aren't recorded
anywhere.
Fatal severity level errors (20 -25), are logged in the
error log and the application log.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros ?
>Errors in severity level 20 to 25 are always logged?
>Thanks
|||And one other thing to add...they are stored in the
sysmessages table in master. The dlevel indicates if they
are logged or not.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros ?
>Errors in severity level 20 to 25 are always logged?
>Thanks
|||Wich is the value for logged error?
Is 128 ?
Thanks
"Sue Hoegemeier" wrote:

> And one other thing to add...they are stored in the
> sysmessages table in master. The dlevel indicates if they
> are logged or not.
> -Sue
> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
> favero@.discussions.microsoft.com> wrote:
>
>
|||Yup...128 is logged.
-Sue
On Wed, 16 Mar 2005 07:17:04 -0800, "andrea favero"
<andreafavero@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Wich is the value for logged error?
>Is 128 ?
>Thanks
>"Sue Hoegemeier" wrote:

How to find logged errors and not-logged erros

Alert don't fire if error is not logged.
How to find logged errors and not-logged erros '
Errors in severity level 20 to 25 are always logged?
ThanksFor logged errors, look in the application log and the SQL
Server error log. Messages that aren't logged you won't find
anywhere. They aren't logged so they aren't recorded
anywhere.
Fatal severity level errors (20 -25), are logged in the
error log and the application log.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||And one other thing to add...they are stored in the
sysmessages table in master. The dlevel indicates if they
are logged or not.
-Sue
On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
favero@.discussions.microsoft.com> wrote:

>Alert don't fire if error is not logged.
>How to find logged errors and not-logged erros '
>Errors in severity level 20 to 25 are always logged?
>Thanks|||Wich is the value for logged error?
Is 128 ?
Thanks
"Sue Hoegemeier" wrote:

> And one other thing to add...they are stored in the
> sysmessages table in master. The dlevel indicates if they
> are logged or not.
> -Sue
> On Tue, 15 Mar 2005 07:51:03 -0800, "andrea favero" <andrea
> favero@.discussions.microsoft.com> wrote:
>
>|||Yup...128 is logged.
-Sue
On Wed, 16 Mar 2005 07:17:04 -0800, "andrea favero"
<andreafavero@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Wich is the value for logged error?
>Is 128 ?
>Thanks
>"Sue Hoegemeier" wrote:
>