Posted by scoots987 on 12/05/07 14:02

On Dec 4, 4:33 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Hugo Kornelis (h...@perFact.REMOVETHIS.info.INVALID) writes:
> >>Another column could be used to track who changed it. Is there a neat
> >>way to determine username, machine name, MAC address or any other
> >>method? I pretty wide open on this one as I am not sure what I want to
> >>use here.
>
> > Check out SUSER_SNAME() and HOST_NAME() in Books Online.
>
> There's far too many functions for the current user for it to be
> healthy.
>
> The best to use, though, is probably original_login(), because the
> others (SESSION_USER, SYSTEM_USER, suser_sname() etc) gives incorrect
> information if there is an EXECUTE AS clause somewhere along the line.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks for the replies.

Are there examples of creating a trigger for tracking table data
changes? Since I never created one before.

Thanks again...

• Next in forum: Query crashes server
• Prev in forum: Connection problem to Informix from SQL Server 2005 with Unicode data
• Thread view: Re: Add a datestamp to an existing table

[Reply to this message]