Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?

share|improve this question
    
Are you asking how to read what is stored in the database? –  Troggy Dec 2 '09 at 16:16
    
I need to make sure that each audit event record sufficient information in the audit trails such as date/time of the event, user ID, source, target, type of event, and sucess/failure. –  wahle509 Dec 2 '09 at 16:21
    
Who maintains/controls the database? I am sure they can help you out and get the information you need quickly. –  Troggy Dec 2 '09 at 17:13
add comment

1 Answer

The easiest way would be to use SQL Management Studio to view your database tables, columns, and type of data stored within it. You can also view the triggers, procedures, and functions. Whoever controls this database would have access to this software as it comes with every sql server install. If a lot of these terms make no sense to you, then you might want to contact the database administrator for help getting and verifying the information you need..

You would need a full read access account though to the server to see all elements of the database. The database administrator is the best person to contact as they would know the layout, schema, and relationships.

http://en.wikipedia.org/wiki/SQL%5FServer%5FManagement%5FStudio

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.