Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9732 Views
- Teledata, I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName,
last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DataBaseName')
AND OBJECT_ID=OBJECT_ID('TableName')
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the types of subquery?
What is the use of commit?
How to see existing views in ms sql server?
Mention the differences between sql server and mysql.
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is a view and what are its advantages?
What is 3nf normalization?
Differentiate between truncate vs delete in mssql?
What is triggers in ms sql server?
What is the difference between count and distinct count?
Do you know the policy based administration feature of sql server 2008?
What is acid properties?
What are the properties of the transaction?
Explain index in sql server?
What is mapping schema?
