Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Server Audit RE: SQL Server Audit

  • September 10, 2012 at 6:04 am

    #1535635

    raj_melvin (9/10/2012)

    we are fine to log into a flat file

    but I am unable to capture the required informations like " Hostname" ,"local ip" and "Application Name" ect.

    this is for a enterprise application only I am testing this in development and Audit it running with the missing informations.

    Thanks

    yeah, wrong tool for the right job, I'm thinking;

    I'm reading up a bit deeper on SQL Audit now, but it looks like some of that information is not currently available to the audit process, but is available form the connection information that you can use in a trigger..

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!