How to simulate the trace of some events

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » How to simulate the trace of some events

How to simulate the trace of some events

Rate Topic

Display Mode

Topic Options

Author

Message

gdraghetti

Posted Wednesday, March 13, 2013 10:45 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 22, 2013 1:58 AM
Points: 34, Visits: 307

Hi,

I activated the trace events.

What test queries can I do to get trace of the following Security Audit events ?

Audit Database Object Take Ownership
Audit Server Object GDR
Audit Server Object Management
Audit Server Object Take Ownership

Smile

Thanks to anyone who can help me.

Post #1430525

gdraghetti

Posted Friday, March 15, 2013 8:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 22, 2013 1:58 AM
Points: 34, Visits: 307

In the meantime I solved it. However, thanks to those who read my topic Smile

Post #1431562

Sean Lange

Posted Friday, March 15, 2013 9:40 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 8,641, Visits: 8,273

It would be great if you could share the steps you took so that others coming along here in the future can learn from all of you hard work. Tongue

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1431597

« Prev Topic | Next Topic »

Permissions