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

Answer Posted / kavitha

getdate() doesnt work for the above query

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does top operator do?

748


Explain different types of collation sensitivity?

698


What is the New in SQL server 2008?

728


Explain different types of locks in sql server.

770


What is the need for indexing?

659






What is dirty page?

720


What guidelines should be followed to help minimize deadlocks?

686


Difference between connected and disconnected database in .net with sql server?

764


What is inline variable assignment?

775


Do you know how to make remote connection in database?

706


Does a sql server 2005 select statement require a from?

772


Explain about extended stored procedure?

672


Can we create clustered index on composite key?

684


Does index slows down insert statements?

749


What is data mart? : sql server analysis services, ssas

803