Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9637 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
Do you know what are the steps to process a single select statement?
How much does sql server 2016 cost?
what's the difference between a primary key and a unique key? : Sql server database administration
Where the sql logs gets stored?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What are the dmvs?
Explain a join?
What is instead of dml trigger?
what are constraints? : Sql server database administration
How do I find the sql server instance name?
What program is used to store the data source file?
How to write character string constants or literals in ms sql server?
Can we call stored procedure in trigger?
what are defaults? : Sql server database administration
