Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9649 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 is the use of “join” in sql server?
Can truncate be rolled back?
What do you understand by recursive stored procedure?
How do I manually uninstall an instance of sql server 2016?
What are distributed partitioned views?
What is temporal data type?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
How to write a query with an inner join in ms sql server?
Are semicolons required at the end of sql statements in sql server 2005?
Write a SQL query to delete a table?
Why is replication required on the sql server?
Explain transaction server distributed transaction?
What is the report model project?
What are different types of schemas?
What are “phantom rows”?
