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

Answer Posted / ram

USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what is fill factor?

716


What is transact-sql ddl trigger?

812


How to create a user to access a database in ms sql server using "create user" statements?

726


Explain ms sql server reporting services vs crystal reports?

683


What are partitioned views?

743






What is difference between index seek vs. Index scan?

819


How to use copy and concatenate commands in SQL?

776


How to find Duplicate Records In table?

759


What are the advantages to use stored procedures?

784


Can an automatic recovery be initiated by a user?

763


Explain few of the new features of sql server 2008 management studio

687


What is the difference between stored procedure and functions?

778


How dts is used to extract, transform and consolidate data?

789


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

719


What are key, name and value columns of an attribute? : sql server analysis services, ssas

766