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?
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.