Answer Posted / 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.

Explain the properties of sub-query in sql server?

1016

---

What are the advantages of using stored procedures in sql server?

1011

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1048

---

What is the most common trace flags used with sql server?

1042

---

What the class forname () does?

1062

---

What is partition, how will you implement it? : sql server analysis services, ssas

1046

---

Is it true, that there is no difference between a rule and a check constraint?

1055

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

993

---

Why does sql studio use a single registered database repository? : sql server management studio

999

---

What happens if the update subquery returns multiple rows in ms sql server?

1125

---

What are “lock” hints?

1055

---

Do you know what is openxml in sql server?

1068

---

Tell about MOM Tool(Microsoft Operator Manager)?

1914

---

Explain what are the authentication modes in sql server?

1016

---

Explain the difference between cross join and full outer join?

980

---