Audit Table

From: Michelle (michelle.vanden_at_eglin.af.mil)
Date: 12/29/03 

Date: Sun, 28 Dec 2003 20:34:52 -0800

The current environment is an ASP frontend with IIS 5.0
using (windows authentication) and SQL Server 2000(windows
authentication) on the same machine.

I would like to add two columns onto several tables and
have a timestamp and username inserted into them when a
user performs an update or insert. I believe it's a good
idea to use an insert or update trigger, but I'm not sure
how the asp application delegates who is logged to sql
server.
 
What is the best way to do this?

Do you need to have IIS and Sql server configured a
certain way in order to grab the username from the asp
application?

Relevant Pages

  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Heres a rather broad question...
    ... I'm familiar enough with using ADO with VBScript/Javascript in ASP pages, ... authentication or permission issues with SQL Server 2000. ... IIS user doesn't have the proper permissions to access the database, ...
    (microsoft.public.data.ado)
  • Re: Windows authentication to sql server 2000 question
    ... creating an .asp db app using windows authentication to sql server in that ... other .asp pages that call to the db? ... should I have an immediate database connection to the sql server ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... users must give their logins and passwords again. ... >> We're trying to make our Intranet pages use Sql Server ... >> Windows Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: How can I run asp pages in Local Computer?
    ... database-driven (SQL Server or another db is also an option here) website or ... Kristofer Gafvert - IIS MVP ... >> I programmed some asp pages, ... >> I need run asp pages in local computer because I 'm ...
    (microsoft.public.inetserver.iis)