If I've got a procedure definition that's been saved in source control, could it be necessary or useful to help keep the 'tombstone' current too?
Here's what i'm saying with a 'tombstone':
CREATE proc [dbo].[getCreditTransactions] AS /* 2001-02-12 jdoe : created proc 2003-04-15 kdoe : added handling for credit business rules */ etc...
Not to update the tombstone, would think that people are entering pertinent information when checking the update into source control. It was a large problem inside my last job - it had been company policy but there is no way of applying business rules to enforce the behaviour.
An advantage of getting the tombstone up-to-date could be:
- to determine history without requiring use of source control
- if source control software was transformed - a brief history would not be lost.