Hi

Thanks for ur reply.
Actually I was looking for some sys table where I can
pick the value from. I got that.

There is a column named login_time in SYSPROCESSES
that can fulfillmy purpose.

Thanks once again

Mandeep





--- Michael.[Email Address Removed] wrote:
> If you log failed and successful logins that will
> give you an idea of when
> some one last signed in.
> If you want to find out what was done you may use a
> third party tool
> Lumigent has one which is supposed
> to be pretty good
> Thank you
> Mike Ngong
>
>
>
>
> Mandeep Bhutani <[Email Address Removed] 11/25/2003 01:54 AM
>
>
> To: "LazyDBA.com Discussion"
> <[Email Address Removed] cc:
> Subject: Last time DB Accessed.
>
>
> Hi All,
>
> Is it possible to find out when was the database
> last
> accessed?
> Is there any system procedure or system table that
> holds any such entry??
>
> Thanks in advance.
>
> Regards
> Mandeep
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
>
>
>


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
MS Sql Server LazyDBA home page