Dear all, I need to know given a datatable wether it is sorted or not. I need this to reverse the sorting (i.e. if it is sorted Asc make it Desc and vise verca) Thank u alot. Rania Adel

Hi Mike, yes it support triggers, and there is already a trigger that perform the task i need, but its very very very slow, and i am responsible of doing it programatically or to enhance the trigger Thank u Rania Adel

Dear all, I have the following case: In a SQL db, each time a row is changed in a specific table ( say OriginalTable ) i need to insert a row for each changed column in a specific table say ( HistoryTable ) by the following values: 1- The OriginalTable Column name ( i.e. the column that its value is changed ) 2- The Old value ( existing before the update process ) 3- The New value ( existing after the update process ) I dont know if this can be done using SQL or programmatically from the code. Plz, if anyone know the solution of that problem using any SQL or Code reply me as soon as possible. ( Note : my application is an ASP.Net c# project) thank u all Rania Adel

Dear all, I have the following case: In a SQL db, each time a row is changed in a specific table ( say OriginalTable ) i need to insert a row for each changed column in a specific table say ( HistoryTable ) by the following values: 1- The OriginalTable Column name ( i.e. the column that its value is changed ) 2- The Old value ( existing before the update process ) 3- The New value ( existing after the update process ) I dont know if this can be done using SQL or programmatically from the code. Plz, if anyone know the solution of that problem using any SQL or Code reply me as soon as possible. ( Note : my application is an ASP.Net project) thank u all Rania Adel