How to find the date and time of last updated table?
- 6 Answers
- 8168 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 query and subquery?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
State the difference between union and union all?
List all types of constraints in sql server?
What is a schema in ms sql server 2005?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is multi-statement table-value user-defined function?
What is not null constraint?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How to convert numeric values to integers in ms sql server?
How to start and end transact-sql statements?
What is the report builder?
what are different types of backups available in sql server? : Sql server database administration
What is NOT NULL Constraint in sql server 2012?
Explain primary key and foreign key constraints?
