Audit logins

Is there a way to identify users within sql server 2005/2000 that have not
accessed a database within 90 days ?In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:71562115407e5@.uwe...
> Is there a way to identify users within sql server 2005/2000 that have not
> accessed a database within 90 days ?
>|||Tibor Karaszi wrote:
>In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
>> Is there a way to identify users within sql server 2005/2000 that have not
>> accessed a database within 90 days ?
Thanks ! Any idea in SQL 2000 ?|||Having a Profiler (server-side) trace running is the only way I can see...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:7156d142d3854@.uwe...
> Tibor Karaszi wrote:
>>In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
>> Is there a way to identify users within sql server 2005/2000 that have not
>> accessed a database within 90 days ?
> Thanks ! Any idea in SQL 2000 ?
>