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 / kavitha

getdate() doesnt work for the above query

Answer / ramendra kumar

TO FIND THE NEW DATE ABOUT LAST RECENT CONFIGURE TABLE
SYNTEX WE BRING IN USE TO SEE THE DATE IS
GETDATE()

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

Explain nested trigger in sql?

0 Answers  

---

Working with TLogs

0 Answers  

---

Explain about sql server login?

0 Answers  

---

What is field in algebra?

0 Answers  

---

---

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,

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

What is log ldf?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

How you can add messages to the nt event log from within a stored procedure?

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---