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 |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2009-12-02 : 01:30:47
|
| Hi All, I have a table where i m not putting column for any modification made in terms of insert,update etc. like modified date.Now issue is can i still know when the table or its column was last modified i.e is latest update on column and tables whichever presented in query. Thanks |
|
|
ajitgadge
Starting Member
12 Posts |
Posted - 2009-12-22 : 07:58:58
|
| --use below dmv and observe the last_user_update column..SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*FROM sys.dm_db_index_usage_statsWHERE database_id = DB_ID( 'dbname')AND OBJECT_ID=OBJECT_ID('tablename') |
 |
|
|
|
|
|
Last Modified Date for a Column of any Table