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 |
|
vinoo128
Starting Member
9 Posts |
 Posted - 2009-01-21 : 14:55:49
|
| Is there a way to know when was a particular table last updated? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 14:58:41
|
quote:
Originally posted by vinoo128
Is there a way to know when was a particular table last updated?
You can find that with DML triggers. |
 |
|
|
vinoo128
Starting Member
9 Posts |
Posted - 2009-01-21 : 14:59:54
|
| Is there a system table you need to query for that or waht? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 15:00:51
|
| You can't find that with system table or DMV. |
|
|
|
vinoo128
Starting Member
9 Posts |
Posted - 2009-01-21 : 15:02:29
|
| Is there a system table you need to query for that or waht? |
|
|
|
vinoo128
Starting Member
9 Posts |
Posted - 2009-01-21 : 15:04:12
|
| could you guide me with the syntax as i am new to SQL Server? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 15:05:16
|
| Or See this:http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/03/determining-the-last-update-to-or-select-against-a-table-without-a-trigger.aspx |
|
|
|
|
|
|
table last updated