I need some good tips how you document changes for a database.
I have seen tables like
CREATE TABLE [dbo].[SchemaChangeLog](
[ID] [int] IDENTITY(1,1) NOT NULL,
[MajorReleaseNumber] [varchar](2) NOT NULL,
[MinorReleaseNumber] [varchar](2) NOT NULL,
[PointReleaseNumber] [varchar](4) NOT NULL,
[ScriptName] [varchar](50) NOT NULL,
[DateApplied] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED ([SchemaChangeID] ASC)
this will handle some type of version history,
So, any tips (best practice) to handle version history of a database would be great?