Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9931 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 rank function?
Where actually sql azure database is hosted?
What is history table in sql server?
How to connect sql server management studio express to sql server 2005 express?
Which tcl commands are available on the sql server?
What are “unrepeatable reads”?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How can you hide the sql server instances?
What is master database? : SQL Server Architecture
What are data driven subscriptions?
What is the command used to recompile the stored procedure at run time?
What does REVERT do in SQL Server 2005?
What are recommended options to be used while using db mirroring? : sql server database administration
Can you name some of the dml commands in sql?
What are the different index configurations a table can have?
