<div>
Im not 100% sure what you're trying to accomplish based on your description....
</div>


<div>
HI chapmandew<br />
<br />
Just to clarify, lets assume I have a Table T with numeric Columns c1 and c2 , those columns actually represent the customer actual usage of my product according to the license. My report actually displays the actual usage VS. the usage that is in the customer license, therefor, I want to prevent manual editing of c1 &amp;&nbsp;c2 by the customer.<br />
<br />
Hope that it is clear now ...<br />
Thanks
</div>


<div>
OK, so you want something at the db level to ensure those values do not get updated once they are inserted...correct?
</div>


<div>
Yes , that is the simplest solution , however, assuming that the customer admin has a sa role , it is easy to drop the trigger , change the value and recreate the trigger , isn't it ???
</div>


<div>
HI <br />
<br />
After investigation , I think I will use this one<br />
<a href="http://pawlos.blogspot.com/2006/04/sqldependency-nice-way-to-monitor.html" rel="ugc">http://pawlos.blogspot.com/2006/04/sqldependency-nice-way-to-monitor.html</a><br />
<br />
and use the notification to revert the change.<br />
<br />
Thanks anyway for your help , the points are yours anyway .....
</div>


<div>
<div class="content wysiwyg-content">
HI<br />
I have to monitor product usage by my customers, and I am asked to store the collected information per date in the table and create a report on that table.<br />
The administrator of the application has the sa DB role , so , he is able to change anything, including collected data.<br />
I am looking for a way to make such a change difficult and noticeable.<br />
One option that I can think of is to add (in my c# service) listeners on that table. <br />
Another option is to use another table having that data encrypted and synchronize the tables each X hours (I have no option to decrypt the data on my reporting tool , so I need another table)<br />
What are the best solutions you know?<br />
Thanks<br />

</div>
</div>


HI
I have to monitor product usage by my customers, and I am asked to store the collected information per date in the table and create a report on that table.
The administrator of the application has the sa DB role , so , he is able to change anything, including collected data.
I am looking for a way to make such a change difficult and noticeable.
One option that I can think of is to add (in my c# service) listeners on that table. 
Another option is to use another table having that data encrypted and synchronize the tables each X hours (I have no option to decrypt the data on my reporting tool , so I need another table)
What are the best solutions you know?
Thanks


Need an advice

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.