Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9462 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 are system databases into sql server (2005/2008)?
how you can deploy an ssrs report?
What does it mean to manipulate data?
What are the advantages of having an index on the sql server?
Explain difference between control flow and data flow?
what is an index? : Sql server database administration
Would you store your query in a ssrs report or a database server? State the reason why?
Can we add our custom code in ssis?
What is candidate key with example?
What is a trigger what are the advantages of trigger?
Explain having clause and where clause?
Distinguish between nested subquery and correlated subquery?
What is difference between stored procedure and user defined function?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Explain timestamp datatype?
