SQL SERVER TIME STAMP

[Yogesh Ajmere]

We have a problem in accesing the records from the SQL Server Database. We do not have any Date field incorporated in the table which will show when the record is last added/modified (Record TIMESTAMP). We want to access the records added on specific date or records added/modified after specified date using sqk query. Is their any method of accessing the Date/Time Stamp for the records via SQL Query.

Thanking You
Yogesh Ajmere

[balajikandaswamy]

Built-in audit information is not available in SQL Server 2000 unless u have specific timestamp column for that.