<div>
Typically data auditing like this is very expensive in way one or another. For example, there are applications that sit on the database that will log every change to every column. These solutions are very resource expensive as well as $$. <br />
<br />
What I've done in the past is understand from a business aspect what information is really needing to be audited and logged. After you identify the columns, write a trigger that either logs the change into an audit table or fires off an alert. Lastly, another option is to implement auditing at the entire database level.<br />
<br />
It really just depends on what you requirements really are and what $$ you have to work with. 
</div>


Typically data auditing like this is very expensive in way one or another. For example, there are applications that sit on the database that will log every change to every column. These solutions are very resource expensive as well as $$.

What I've done in the past is understand from a business aspect what information is really needing to be audited and logged. After you identify the columns, write a trigger that either logs the change into an audit table or fires off an alert. Lastly, another option is to implement auditing at the entire database level.

It really just depends on what you requirements really are and what $$ you have to work with.

<div>
Cost isn't really an issue, but the basic things I need to log are<br />
<br />
date<br />
time<br />
user<br />
description of event<br />
database changes
</div>


Cost isn't really an issue, but the basic things I need to log are

date
time
user
description of event
database changes

<div>
<div class="content wysiwyg-content">
Is there an easy way to see what fields have changed in a database.<br />
<br />
I have an audit requirement that basically needs me to determine what changed<br />
<br />
So when I do an update, I would ideally like to know what columns and fields changed<br />
<br />
Something like<br />
<br />
Name: Fred Fluntstone <br />
<br />
changed to <br />
<br />
Name: Fred Flintstone<br />

</div>
</div>


Is there an easy way to see what fields have changed in a database.

I have an audit requirement that basically needs me to determine what changed

So when I do an update, I would ideally like to know what columns and fields changed

Something like

Name: Fred Fluntstone 

changed to 

Name: Fred Flintstone


Audit of Database Changes

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.