what is SQL server Auditing and how to setup auditing ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » what is SQL server Auditing and how to setup...

what is SQL server Auditing and how to setup auditing ?

Rate Topic

Display Mode

Topic Options

Author

Message

pxt_ce

Posted Wednesday, February 03, 2010 5:09 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 1:55 AM
Points: 405, Visits: 332

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

Post #858532

Roy Ernest

Posted Wednesday, February 03, 2010 5:34 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:24 AM
Points: 3,280, Visits: 6,619

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

Post #858545

« Prev Topic | Next Topic »

Permissions