hey have you looked into 2008's change tracking? its table level and attempts to solve the very problem you have

http://www.databasejournal.com/features/mssql/article.php/3875186/A-Look-at-SQL-Server-2008-Change-Tracking.htm

I came across the feature a while back...

Basically, you cannot do that from inside SQL Server's hosted CLR.

Do it in your process by creating your own EXE and saving the resulting image to SQL.

This is a prime...