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

  • September 12, 2012 at 9:30 am

    #1536784

    raj_melvin (9/12/2012)

    Thanks for your reply.

    Trigger - yes it's working solution But the company doen't wanted to use the trigger

    SQL Profiler - unable to trace it in a table - Getting error "Failed to Save table <tablename> cursor operation conflict"

    SQL Audit - How to get the Hostname, program name etc...

    No idea about the error in profiler; my suggestion was a server side trace.

    take a look at that and see if it you can get your arms around that instead.

    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!