what is SQL server Auditing and how to setup auditing ?

  • What is SQL Server Auditing? and how to setup. I am not clear and this is kind of new thing to me.

    would you please explain in short about SQL Server Auditing?

    As per my understanding we can audit login using Profiler. but m not much more clear.

    please give me your valuable input.

    Pd

  • Auditing is a pretty big topic to give you an explanation in a forum. The best thing to do would be to read up on it and then come back and ask doubts I am sure everyone here will help you out. To begin with, here is a good link from MSDN that gives the basic information regarding Auditing. And it also has other links that you can drill down to get a better understanding of Auditing.

    http://msdn.microsoft.com/en-us/library/cc280386.aspx

    If you want to read a great white paper on What and how to set up Auditing for 2008, here it is.

    http://msdn.microsoft.com/en-us/library/dd392015.aspx

    -Roy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply