How to find the date and time of last updated table?
- 6 Answers
- 8535 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
What is the difference between varchar and varchar types?
Define left outer join in sql server joins?
How to sort query output in descending order in ms sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain few of the new features of sql server 2008 management studio
How would we use distinct statement? What is its use?
how would you troubleshoot blocking? : Sql server database administration
What is a print index?
What is the importance of concurrency control?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is reference section?
What are pages and extents? : SQL Server Architecture
Do you know concepts and capabilities of sql server?
Explain iaas, paas and saas?
