Last connect/update/modify date

Hi all,
Could anyone give me any information on how to obtain information from my SQL Server db's that will indicate the date of last connection/update/user activity?
Many thanks,
MeganThere are SP's and other ways to list some info about what's happening right now in the database, but I can't find anything about what happened earlier.
Maybe a log explorer tool could help with some parts.|||Thanks for the response :)|||Under Management -> Current Activity, will give you some information. You can also enable successful/failed login auditing - this is probably what you will need to enable as well as using sql profiler.|||The following is a good article:

article (http://www.ddart.net/mssql/sql2000/html/adminsql/ad_security_2ard.htm)|||Is the contents of that web site the same as in Books On-Line?|||> You can also enable successful/failed login auditing

Where do I do this?|||SQL profiler is the best tool for this - but you can also use auditing under the sql server properties -> security -> "Audit Level". Under SQL Profiler - Create a trace -> Events - you will see several auditing choices.|||Thanks to all who responded!

I ended up creating a custom trace template in Profiler and create my trace files based on it.
It's not awe-inspiring, but it's the only solution I've come across so far without looking at purchasing some kind of 3rd party log-miner/auditing software.