Re: Machine Name In Trigger
From: Dean (dvitner_at_nospam.gmail.com)
Date: 02/28/05
- Next message: dw: "Re: Counting votes"
- Previous message: Bob Barrows [MVP]: "Re: performance tradeoff b/w stored procedure and views"
- In reply to: Neil: "Re: Machine Name In Trigger"
- Next in thread: Neil: "Re: Machine Name In Trigger"
- Reply: Neil: "Re: Machine Name In Trigger"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Feb 2005 13:54:49 +0100
try suser_sname()
dean
"Neil" <njones@pxdy.com> wrote in message
news:wGAUd.7684$873.5789@newsread3.news.pas.earthlink.net...
> Here's what I got:
>
> ID Login Name
> User Name
> ------ -------------------------------------------------------------------
-------------------------------------------------------------
> -------------------------------------------------------------------------
-------------------------------------------------------9 sadbo(1 row(s)
affected)I was looking for the Windows account that's currently logged in,
if that'spossible.Thanks."Vinod Kumar" <vinodk_sct@NO_SPAM_hotmail.com>
wrote in messagenews:cvmtl9$ufs$1@news01.intel.com...> Check if this
helps:>> SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User
Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD>
http://www.extremeexperts.com>> Books Online for SQL Server SP3 at>
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp>> "Neil"
<njones@pxdy.com> wrote in message>
news:6_xTd.5362$873.4937@newsread3.news.pas.earthlink.net...>> Any function
for getting the current Windows user?>>>> Thanks!>>>>>> "Tom Moreau"
<tom@dont.spam.me.cips.ca> wrote in message>>
news:OjjQtktGFHA.4032@TK2MSFTNGP12.phx.gbl...>> > Check out HOST_NAME() in
the BOL.>> >>> > -->> > Tom>> >>>
> ---------------------------------------------------->> > Thomas A. Moreau,
BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist, SQL Server
Professional>> > Toronto, ON Canada>> > www.pinnaclepublishing.com>> > .>>
> "Neil" <njones@pxdy.com> wrote in message>> >
news:N1vTd.5219$873.4670@newsread3.news.pas.earthlink.net...>> > Is it
possible to get the machine name in a trigger so that it can be>> > stored>>
> in a field?>> >>> > Thanks.>> >>> >>>>>>>
>
- Next message: dw: "Re: Counting votes"
- Previous message: Bob Barrows [MVP]: "Re: performance tradeoff b/w stored procedure and views"
- In reply to: Neil: "Re: Machine Name In Trigger"
- Next in thread: Neil: "Re: Machine Name In Trigger"
- Reply: Neil: "Re: Machine Name In Trigger"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
