Take the 2-minute tour ×  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  1 Answer 1  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 cont