Update a field after a user logs in

30 Jun 2006 2:49 PM

jmawebco

I have a .NET application (2.0) and would like to do the following;

A user logs into the system and when his/her identity is validated a
field is updated to mart the individual as online. I want to do this by
use of a trigger so that when the user validation passes the record for
that individual gets updated to reflect he/she is online.

Any suggestions would be appreciated.

Thanks,

Jaime

30 Jun 2006 3:40 PM

Aaron Bertrand [SQL Server MVP]

Don't you have a stored procedure that validates the identity?

Why not do it there? I don't understand why a trigger needs to do this,
when you already have something thatis fully capable of it...

A

Show quote

"jmawebco" <jaime.c***@infrasourceinc.com> wrote in message
news:1151678961.076819.158670@h44g2000cwa.googlegroups.com...
>I have a .NET application (2.0) and would like to do the following;
>
> A user logs into the system and when his/her identity is validated a
> field is updated to mart the individual as online. I want to do this by
> use of a trigger so that when the user validation passes the record for
> that individual gets updated to reflect he/she is online.
>
> Any suggestions would be appreciated.
>
> Thanks,
>
> Jaime
>