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

  • September 10, 2012 at 5:52 am

    #1535632

    raj_melvin (9/10/2012)

    Thanks Very Much this is really usefull.

    Appriciate your help.

    is there is anyway we can get the same output using the SQL Audit

    please help,

    To the best of my knowledge, SQL Audit writes to a file or to a either the Security Log or the Application Log of the operating system, so writing to a table is not an option.

    Also, is SQL Audit available in Standard edition, or is that an enterprise only system?> Since I'm running the Developer edition, I'm not sure Audit is what you want to use.

    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!