Print 'Doing pre run Checks to ensure script not already run'; Select * from Script_History where Script_Name='Hotfix14112023'; if @@ROWCOUNT!=0 BEGIN RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1); RETURN; END GO UPDATE System_Default SET Default_Value = '2.0.3.3' where Default_Name = 'CurrentVersionNumber' Print 'Insert into script history if everything else is cool'; Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'Hotfix14112023'); IF @@ERROR != 0 BEGIN RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1); RETURN; END GO