You can use SQL Profiler or the C2 auditing function to monitor logins to SQL Server. C2 is probably a bit over the top for what you want. Both of these can be used to monitor when a user logs onto the SQL Server itself and not just into a specific Database. In order to add a trigger I think you would need to add it to the master database but of the top of my head I wouldnt know which table, I'm not sure its even possible. I think setting up a trace through profiler that writes to a table would probabaly be a better option.

Just some thoughts.

>Is there a way to write a trigger that to write a record when a user account logs on in SQL Server 2000?
>
>Thanks
>
>Kirk