New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
this will handle some type of version history,
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, CONSTRAINT [PK_SchemaChangeLog] PRIMARY KEY CLUSTERED ([SchemaChangeID] ASC) )