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

How to send a ssrs report from ssis?

143


What do you understand by recursive stored procedures?

656


Explain for xml explicit mode?

651


What are the different index configurations a table can have?

607


How to change parameter value inside the report?

119






Explain log shipping and mention its advantages.

691


How to update multiple rows with one update statement in ms sql server?

739


What is faster join or union?

710


What are the elements of dbms?

629


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

586


What is a user-defined function in the sql server and what is its advantage?

700


What is sql collation?

731


What is the meaning of resultset type_scroll_insensitive?

646


Why would you call update statistics?

680


What is data source in connection string?

560