CREATE TABLE [dbo].[ClusterNodesHystory]
(
[ID] [int] IDENTITY(1,1) NOT NULL CONSTRAINT [PK_ClusterNodesHystory_ID] PRIMARY KEY CLUSTERED ,
[CurrentNode] [varchar](100) NULL,
[PreviousNode] [varchar](100) NULL,
[TimeStamp] [datetime] NOT NULL CONSTRAINT [DF_ClusterNodesHystory_TimeStamp] DEFAULT (GETDATE()),
)
GO
and then as last part of the script:
INSERT INTO [dbo].[ClusterNodesHystory]([CurrentNode],[PreviousNode])
SELECT @curnodename,@prevnodename;
so that way we have full history records