Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Modify Dates

Status
Not open for further replies.
seekwall

seekwall

Programmer
May 14, 2001
41
GB
Does anyone know of a way of returning the date an object was last updated ? ( without having to use the transaction log )

There doesn't seem to be anything useful within the sysobjects table
 
Sort by date Sort by votes

There is not built in way. Youi either have to create your own audit trail or buy third party software to do this. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

barim
  • Locked
  • Question
Compare Dates With Current Date
Replies
3
Views
220
barim
barim
kingz2000
  • Locked
  • Question
select data with date condition, choosing latest values from selected dates 2
Replies
16
Views
694
Andrzejek
Andrzejek
gooseriver
  • Locked
  • Question
SQL Query - Between two dates
Replies
4
Views
241
gooseriver
gooseriver
wbodger
  • Locked
  • Question
Constraint to modify value if not unique
Replies
3
Views
305
DaveInIowa
DaveInIowa
Starscream_2017
  • Locked
  • Question
Find missing dates with a range for one table
Replies
4
Views
188
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top