Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #210

Re: A Question on Triggers

Show all headers | View raw

On Apr 25, 11:38 am, Dom <dolivas...@gmail.com> wrote:
> I'm just reading through the help sites for information about creating
> a Trigger.  I'm using it to debug a program.  The trigger will record
> the exact time a record is updated in a certain table.  My question
> is:  Is there any way to capture the user that is doing the updating?
> For example is there something like a GET_USER_ID() function that I
> can record in the trigger?
>
> Thanks, Dom

SYSTEM_USER is documented in as returning the login name of the
current user.  What it seem to return in my environment is the login
ID of the current user, in the form [domain]\[userid] where [domain]
is the short or local domain name.

Fred.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

A Question on Triggers Dom <dolivastro@gmail.com> - 2011-04-25 08:38 -0700
  Re: A Question on Triggers "Fred." <ghrno-google@yahoo.com> - 2011-04-25 09:12 -0700
    Re: A Question on Triggers Dom <dolivastro@gmail.com> - 2011-04-25 10:51 -0700
    Re: A Question on Triggers Erland Sommarskog <esquel@sommarskog.se> - 2011-04-25 20:42 +0200

csiph-web