Answer / payal nath

We can determine the last time a user table was altered
using the below query.

SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC

The modify_date column is updated whenever a column is
added or altered for the table.
It is also updated if the clustered index is changed.

Answer / manoj

select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)

Answer / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

how to rest identity columns in sql server

3 Answers   Matrix,

---

---

How to copy data from one table to another table?

0 Answers  

---

How to run queries with sql server management studio express?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

Explain about system stored procedure?

0 Answers  

---

Can we create clustered index on composite key?

0 Answers  

---

How do I uninstall sql server 2014?

0 Answers  

---

How does a profiler work?

0 Answers  

---