Need a guru

To all guru's:
I have something that sounds simple in theroy, but I haven't quite figured
out what I need to do to accomplish this. Simply put here is what I'd like t
o
do.
1. User logs into database/application
2. Upon login, update a table that contains the users login name (not
sysxlogins or sysusers) with the time of the login.
I've tried several update scripts, but none of them work. I think I'm at a
wall and hoping someone could provide a sample of what I could do to
accomplish this.If it's via an application, you could easily trigger a customised stored
procedure that logs username/date into a table.
i.e create sp to insert data , exec sp when logging in
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Big Ern" <BigErn@.discussions.microsoft.com> wrote in message
news:7F42AC1C-775B-4900-91B7-47CD4A3F13F0@.microsoft.com...
> To all guru's:
> I have something that sounds simple in theroy, but I haven't quite figured
> out what I need to do to accomplish this. Simply put here is what I'd like
to
> do.
> 1. User logs into database/application
> 2. Upon login, update a table that contains the users login name (not
> sysxlogins or sysusers) with the time of the login.
> I've tried several update scripts, but none of them work. I think I'm at a
> wall and hoping someone could provide a sample of what I could do to
> accomplish this.