Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9708 Views
- Teledata, I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar
SELECT OBJECT_NAME(OBJECT_ID) AS tablename,
last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'your_database_name')
and user_updates>0
order by last_user_seek desc
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where do you find the default Index fill factor and how to change it?
What is difference between rownum and row_number?
Do you know nested transaction?
What is dml command?
Explain about system stored procedure?
How to use order by with union operators in ms sql server?
Define a cross join?
What does the on delete cascade option do?
Is mysql better than sql server?
What are the types of indexes?
What is the server name in sql server?
What is normalization? Explain different forms of normalization?
What is attribute hierarchy? : sql server analysis services, ssas
How do clustered indexes store data?
What is the use of floor function in sql server?
