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()

How many triggers are possible per table?

0 Answers  

---

What is Transparent Data Encryption?

0 Answers  

---

How to use user defined functions in expressions?

0 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

What are data files?

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---