Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .