Modified Date time of a SQL Server Table

[Aarvee]

In my application, I am creating a dataset and loading the required tables into that when the application loads. Periodically I need to check back with the backend database to see whether any of the contents have changed and if so refresh the dataset with the fresh contents. For this purpose I need to find out the modified date and time of the backend table in SQL Server 2000 through VB.Net.

Can someone help me how to do this ?

Thanks in advance
Varadarajan R

 

[TechGnome]

The "modified" date of a table has to do with the table structure... not the data in it.

-tg

 

[Aarvee]

If it is not the "modified date" that I should look for, is there any other parameter that I can compare to identify whether any changes have taken place ? I first thought of the row count but felt that it would not trap situations when the row contents only would have changed keeping the number of rows same.

Thanks

Varadarajan R