One common approach is to keep a timestamp on each row. Update the timestamp anytime that the row is modified.
For you application, when the user logs in, you'll look for rows that were changed since the last login date/time.
Watch out for the timestamp datatype. It's not a date/time value but a binary value. You'll probably want to go with a true datetime and update the value yourself when the rows are modified. This is easy to do with a trigger or in stored procedures.
-Mike
>Is there a way to check if content of a Table has changed since last logon.
>
>In order to improve performance of a Client/Server app I want to transfer a table contents to a client machine. And next time when user logs on to check if the contents of that table has changed, in order to transfer again or not.
>(changes during the logon session are not relevant)
>
>Any help will be appreciated