Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
justsubby
Starting Member
1 Post |
 Posted - 2008-02-28 : 16:56:22
|
| Hi,I have a small question regard how to find out if a specific table has chanced.Is there any (sql)function inside MSSQL2005 that I can use to find if a spesific table has changed? I have heard of timestamp, but I don't know if that will solve my problem? Is there any thing in the sys.tables that kan help me, just do a fast query and check if a table has changed?I'm developing a web-application with AJAX.NET, and I have UpdatePanels with datalist. When the tables in the db gets big the application is henging for a sec or two when it receiving the data, and when the timer (refresh rate) is 2 min it is not good! So my plan is to check if the table has chanced since last transfer of data, and if it has it will download the data, if not do nothing.Jonny |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-28 : 17:26:40
|
| Can you put a LastModified column in the table? If so, you can update each record when it is updated and just query the latest date from the table. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:31:20
|
| Sql2k8 will have that feature. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-03-02 : 14:31:05
|
| checksum feature.That should help you. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-02 : 18:20:08
|
sys.objects has modify_date, but that's only bumped if the schema of the table changes (like you add or drop a column)
elsasoft.org |
|
|
|
|
|
|
How to find out if a spesific table has changed?