getdate() doesnt work for the above query

How to find the date and time of last updated table?

Question Posted / kavitha

Answer Posted / kavitha

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1060

Tell me what is a linked server?

1040

How to find the second highest salary of an employee?

1179

How to grant a permission in ms sql server using "grant execute" statements?

1093

Which are new data types introduced in sql server 2008?

1049

What are horizontal and vertical scaling?

172

How to throw custom exception in Stored Procedure?

1044

How do you use a subquery to find records that exist in one table and do not exist in another?

1049

Mention the 3 ways to get a count of the number of records in a table.

978

How will you decide the active and passive nodes?

1129

How to select an exiting database using mssql_select_db()?

989

What new changes are being made in SQL Server?

1187

What is the use of commit?

1000

What is the default order of an order by clause?

995

List the different index configurations possible for a table?

934