Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9463 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
where can you add custom error messages to sql server? : Sql server administration
Explain comment on transactions?
How can you list all the columns in a database?
Does hive support indexing?
What are SSL and TSL protocols?
Define synonym?
Explain try...catch with sql server?
What is BCNF? How is it better than 2NF & 3NF?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is a unique key constraint?
What is the sql server 2000 version number?
What are the various editions of sql server 2017 that are available in the market?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Can a database be shrunk to 0 bytes, if not, why?
What is a rownum?
