Using the Service Audit Object in SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Kelley » Using the Service Audit Object in SQL Server...

13 posts, Page 2 of 2

««1 2

Using the Service Audit Object in SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

440692 I am just a number

Posted Thursday, August 11, 2011 7:47 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:57 AM
Points: 1,632, Visits: 2,041

Great article.
Is there a way to roll over the logs on a time basis or manually?
I'm thinking of some sort of
DBCC ERRORLOG
sp_cycle_errorlog
equivilant

Post #1158472

Achilies

Posted Monday, March 05, 2012 1:12 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 10:58 AM
Points: 226, Visits: 394

Good article,
I know to view audit logs, we can right click from SSMS to the audit specification and view them if the object has made the destination to a file. But how to view the audit logs, if the destination has given to windows/application log. Right now i am viewing the audit logs (given to windows/application log) going to event viewer and opening the windows logs. Is there any way that we view these right from SSMS?

Thanks..

Post #1261798

440692 I am just a number

Posted Tuesday, March 06, 2012 3:57 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:57 AM
Points: 1,632, Visits: 2,041

Beginner_2008 (3/5/2012)

I do not have my audit files set up this way, so can not be sure, but have you looked under Management, SQL ServerLogs. here you can select logs for Windows NT, application

Post #1262041

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions