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 |
|
senpark15
Starting Member
4 Posts |
 Posted - 2008-05-09 : 08:06:28
|
| hello everybody, i have one problem, I want to check the database table modified or not for every five minutes , how can check? please help me Senthil |
|
|
pootle_flump
1064 Posts |
Posted - 2008-05-09 : 08:15:02
|
| Hi SenthilIt sounds like you have come to a conclusion as to what the solution should be. This is unlikely to be the best way to do things. Could you work backwards a bit and explain what problem you are trying to solve by checking the table? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-09 : 08:17:54
|
Dare I suggest DDL trigger for alterations to table layout?Or DML trigger for "moditications" such as DELETE/INSERT/UPDATE?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Check whether the database table has been modified