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

Re: A Question on Triggers

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!feeder.news-service.com!postnews.google.com!z33g2000vbk.googlegroups.com!not-for-mail
From	Dom <dolivastro@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: A Question on Triggers
Date	Mon, 25 Apr 2011 10:51:47 -0700 (PDT)
Organization	http://groups.google.com
Lines	23
Message-ID	<4bc84178-d091-42f5-b664-c04d6b3a0faa@z33g2000vbk.googlegroups.com> (permalink)
References	<77111122-3944-48ad-923b-dd0a3329d071@u38g2000prd.googlegroups.com> <2a56545e-0788-4534-ae23-b93430c877a6@t19g2000prd.googlegroups.com>
NNTP-Posting-Host	75.146.237.203
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1303753907 30782 127.0.0.1 (25 Apr 2011 17:51:47 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Mon, 25 Apr 2011 17:51:47 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	z33g2000vbk.googlegroups.com; posting-host=75.146.237.203; posting-account=a9GgtgoAAACd0R3qq67_hdwxiGZYZuHZ
User-Agent	G2/1.0
X-HTTP-UserAgent	Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2),gzip(gfe)
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:212

Show key headers only | View raw

On Apr 25, 12:12 pm, "Fred." <ghrno-goo...@yahoo.com> wrote:
> 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.

Thanks, Fred.  Exactly what I wanted.

Dom

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