-- [Target Process] Confidential Data Removal Script -- If you're going to send a backup of your database to TP support -- and want to remove all the sensitive values from your backup -- please run this script against a BACKUP of your database!!! EXEC disableTriggers; -- Board UPDATE [dbo].[ClientStorageData] SET [Value] = '"Board ' + CAST(StorageId AS VARCHAR(10)) + '"' WHERE [Key] = 'name' -- General entities UPDATE [dbo].[General] SET [Description] = 'Description' + CAST(GeneralID AS VARCHAR(10)), [Name] = 'Name' + CAST(GeneralID AS VARCHAR(10)); UPDATE [dbo].[BugHistory] SET [Description] = 'Description' + CAST(BugID AS VARCHAR(10)), [Name] = 'Name' + CAST(BugID AS VARCHAR(10)); UPDATE [dbo].[FeatureHistory] SET [Description] = 'Description' + CAST(FeatureID AS VARCHAR(10)), [Name] = 'Name' + CAST(FeatureID AS VARCHAR(10)); UPDATE [dbo].[ImpedimentHistory] SET [Description] = 'Description' + CAST(ImpedimentID AS VARCHAR(10)), [Name] = 'Name' + CAST(ImpedimentID AS VARCHAR(10)); UPDATE [dbo].[RequestHistory] SET [Description] = 'Description' + CAST(RequestID AS VARCHAR(10)), [Name] = 'Name' + CAST(RequestID AS VARCHAR(10)); UPDATE [dbo].[TaskHistory] SET [Description] = 'Description' + CAST(TaskID AS VARCHAR(10)), [Name] = 'Name' + CAST(TaskID AS VARCHAR(10)); UPDATE [dbo].[UserStoryHistory] SET [Description] = 'Description' + CAST(UserStoryID AS VARCHAR(10)), [Name] = 'Name' + CAST(UserStoryID AS VARCHAR(10)); UPDATE [dbo].[EpicHistory] SET [Description] = 'Description' + CAST(EpicID AS VARCHAR(10)), [Name] = 'Name' + CAST(EpicID AS VARCHAR(10)); UPDATE Comment SET [Description] = 'Description' + CAST(CommentID AS VARCHAR(10)); UPDATE CommentHistory SET [Description] = 'Description' + CAST(CommentID AS VARCHAR(10)); -- Planning UPDATE [dbo].[ReleaseHistory] SET [Description] = 'Description' + CAST(ReleaseID AS VARCHAR(10)), [Name] = 'Name' + CAST(ReleaseID AS VARCHAR(10)); UPDATE [dbo].[BuildHistory] SET [Description] = 'Description' + CAST(BuildID AS VARCHAR(10)), [Name] = 'Name' + CAST(BuildID AS VARCHAR(10)); UPDATE [dbo].[IterationHistory] SET [Description] = 'Description' + CAST(IterationID AS VARCHAR(10)), [Name] = 'Name' + CAST(IterationID AS VARCHAR(10)); UPDATE [dbo].[ProcessHistory] SET [Description] = 'Description' + CAST(ProcessID AS VARCHAR(10)), [Name] = 'Name' + CAST(ProcessID AS VARCHAR(10)); UPDATE [dbo].[ProgramHistory] SET [Description] = 'Description' + CAST(ProgramID AS VARCHAR(10)), [Name] = 'Name' + CAST(ProgramID AS VARCHAR(10)); UPDATE [dbo].[ProjectHistory] SET [Description] = 'Description' + CAST(ProjectID AS VARCHAR(10)), [Name] = 'Name' + CAST(ProjectID AS VARCHAR(10)); UPDATE [dbo].[SquadIterationHistory] SET [Description] = 'Description' + CAST(SquadIterationID AS VARCHAR(10)), [Name] = 'Name' + CAST(SquadIterationID AS VARCHAR(10)); UPDATE [dbo].[SquadHistory] SET [Description] = 'Description' + CAST(SquadID AS VARCHAR(10)), [Name] = 'Name' + CAST(SquadID AS VARCHAR(10)); --QA UPDATE [dbo].[TestCase] SET [Steps] = 'Steps' + CAST(TestCaseID AS VARCHAR(10)), [LastFailureComment] = 'Comment' + CAST(TestCaseID AS VARCHAR(10)), [Success] = 'Success' + CAST(TestCaseID AS VARCHAR(10)); UPDATE [dbo].[TestCaseHistory] SET [Description] = 'Description' + CAST(TestCaseID AS VARCHAR(10)), [Steps] = 'Steps' + CAST(TestCaseID AS VARCHAR(10)), [Success] = 'Success' + CAST(TestCaseID AS VARCHAR(10)), [LastFailureComment] = 'Comment' + CAST(TestCaseID AS VARCHAR(10)), [Name] = 'Name' + CAST(TestCaseID AS VARCHAR(10)); UPDATE [dbo].[TestCaseRun] SET [Comment] = 'Comment' + CAST(TestCaseRunID AS VARCHAR(10)); UPDATE [dbo].[TestCaseRunHistory] SET [Comment] = 'Comment' + CAST(TestCaseRunID AS VARCHAR(10)); UPDATE [dbo].[TestPlanHistory] SET [Description] = 'Description' + CAST(TestPlanID AS VARCHAR(10)), [Name] = 'Name' + CAST(TestPlanID AS VARCHAR(10)); UPDATE [dbo].[TestPlanRunHistory] SET [Description] = 'Description' + CAST(TestPlanRunID AS VARCHAR(10)), [Name] = 'Name' + CAST(TestPlanRunID AS VARCHAR(10)); UPDATE [dbo].[TestStep] SET [Description] = 'Description' + CAST(TestStepID AS VARCHAR(10)), [Result] = 'Result' + CAST(TestStepID AS VARCHAR(10)); UPDATE [dbo].[TestStepHistory] SET [Description] = 'Description' + CAST(TestStepID AS VARCHAR(10)), [Result] = 'Result' + CAST(TestStepID AS VARCHAR(10)); UPDATE [dbo].[FreezedTestCaseInfo] SET [Description] = 'Description' + REPLICATE(CAST('X' AS varchar(MAX)), LEN(Description)); UPDATE [dbo].[FreezedTestStepInfo] SET [Description] = 'Description' + REPLICATE(CAST('X' AS varchar(MAX)), LEN(Description)); -- Time UPDATE [dbo].[Time] SET [Description] = 'Description' + CAST(TimeID AS VARCHAR(10)); UPDATE [dbo].[CustomActivity] SET [Name] = 'Name' + CAST(CustomActivityID AS VARCHAR(10)); UPDATE [dbo].[TimeHistory] SET [Description] = 'Description' + CAST(TimeID AS VARCHAR(10)); UPDATE [dbo].[Time] SET [CustomField1] = 'CustomField1' WHERE [CustomField1] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField2] = 'CustomField2' WHERE [CustomField2] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField3] = 'CustomField3' WHERE [CustomField3] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField4] = 'CustomField4' WHERE [CustomField4] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField5] = 'CustomField5' WHERE [CustomField5] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField6] = 'CustomField6' WHERE [CustomField6] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField7] = 'CustomField7' WHERE [CustomField7] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField8] = 'CustomField8' WHERE [CustomField8] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField9] = 'CustomField9' WHERE [CustomField9] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField10] = 'CustomField10' WHERE [CustomField10] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField11] = 'CustomField11' WHERE [CustomField11] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField12] = 'CustomField12' WHERE [CustomField12] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField13] = 'CustomField13' WHERE [CustomField13] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField14] = 'CustomField14' WHERE [CustomField14] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField15] = 'CustomField15' WHERE [CustomField15] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField16] = 'CustomField16' WHERE [CustomField16] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField17] = 'CustomField17' WHERE [CustomField17] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField18] = 'CustomField18' WHERE [CustomField18] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField19] = 'CustomField19' WHERE [CustomField19] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField20] = 'CustomField20' WHERE [CustomField20] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField21] = 'CustomField21' WHERE [CustomField21] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField22] = 'CustomField22' WHERE [CustomField22] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField23] = 'CustomField23' WHERE [CustomField23] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField24] = 'CustomField24' WHERE [CustomField24] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField25] = 'CustomField25' WHERE [CustomField25] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField26] = 'CustomField26' WHERE [CustomField26] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField27] = 'CustomField27' WHERE [CustomField27] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField28] = 'CustomField28' WHERE [CustomField28] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField29] = 'CustomField29' WHERE [CustomField29] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField30] = 'CustomField30' WHERE [CustomField30] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField31] = 'CustomField31' WHERE [CustomField31] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField32] = 'CustomField32' WHERE [CustomField32] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField33] = 'CustomField33' WHERE [CustomField33] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField34] = 'CustomField34' WHERE [CustomField34] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField35] = 'CustomField35' WHERE [CustomField35] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField36] = 'CustomField36' WHERE [CustomField36] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField37] = 'CustomField37' WHERE [CustomField37] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField38] = 'CustomField38' WHERE [CustomField38] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField39] = 'CustomField39' WHERE [CustomField39] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField40] = 'CustomField40' WHERE [CustomField40] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField41] = 'CustomField41' WHERE [CustomField41] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField42] = 'CustomField42' WHERE [CustomField42] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField43] = 'CustomField43' WHERE [CustomField43] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField44] = 'CustomField44' WHERE [CustomField44] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField45] = 'CustomField45' WHERE [CustomField45] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField46] = 'CustomField46' WHERE [CustomField46] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField47] = 'CustomField47' WHERE [CustomField47] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField48] = 'CustomField48' WHERE [CustomField48] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField49] = 'CustomField49' WHERE [CustomField49] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField50] = 'CustomField50' WHERE [CustomField50] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField51] = 'CustomField51' WHERE [CustomField51] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField52] = 'CustomField52' WHERE [CustomField52] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField53] = 'CustomField53' WHERE [CustomField53] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField54] = 'CustomField54' WHERE [CustomField54] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField55] = 'CustomField55' WHERE [CustomField55] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField56] = 'CustomField56' WHERE [CustomField56] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField57] = 'CustomField57' WHERE [CustomField57] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField58] = 'CustomField58' WHERE [CustomField58] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField59] = 'CustomField59' WHERE [CustomField59] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField60] = 'CustomField60' WHERE [CustomField60] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField61] = 'CustomField61' WHERE [CustomField61] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField62] = 'CustomField62' WHERE [CustomField62] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField63] = 'CustomField63' WHERE [CustomField63] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField64] = 'CustomField64' WHERE [CustomField64] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField65] = 'CustomField65' WHERE [CustomField65] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField66] = 'CustomField66' WHERE [CustomField66] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField67] = 'CustomField67' WHERE [CustomField67] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField68] = 'CustomField68' WHERE [CustomField68] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField69] = 'CustomField69' WHERE [CustomField69] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField70] = 'CustomField70' WHERE [CustomField70] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField71] = 'CustomField71' WHERE [CustomField71] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField72] = 'CustomField72' WHERE [CustomField72] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField73] = 'CustomField73' WHERE [CustomField73] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField74] = 'CustomField74' WHERE [CustomField74] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField75] = 'CustomField75' WHERE [CustomField75] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField76] = 'CustomField76' WHERE [CustomField76] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField77] = 'CustomField77' WHERE [CustomField77] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField78] = 'CustomField78' WHERE [CustomField78] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField79] = 'CustomField79' WHERE [CustomField79] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField80] = 'CustomField80' WHERE [CustomField80] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField81] = 'CustomField81' WHERE [CustomField81] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField82] = 'CustomField82' WHERE [CustomField82] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField83] = 'CustomField83' WHERE [CustomField83] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField84] = 'CustomField84' WHERE [CustomField84] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField85] = 'CustomField85' WHERE [CustomField85] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField86] = 'CustomField86' WHERE [CustomField86] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField87] = 'CustomField87' WHERE [CustomField87] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField88] = 'CustomField88' WHERE [CustomField88] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField89] = 'CustomField89' WHERE [CustomField89] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField90] = 'CustomField90' WHERE [CustomField90] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField91] = 'CustomField91' WHERE [CustomField91] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField92] = 'CustomField92' WHERE [CustomField92] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField93] = 'CustomField93' WHERE [CustomField93] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField94] = 'CustomField94' WHERE [CustomField94] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField95] = 'CustomField95' WHERE [CustomField95] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField96] = 'CustomField96' WHERE [CustomField96] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField97] = 'CustomField97' WHERE [CustomField97] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField98] = 'CustomField98' WHERE [CustomField98] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField99] = 'CustomField99' WHERE [CustomField99] IS NOT NULL UPDATE [dbo].[Time] SET [CustomField100] = 'CustomField100' WHERE [CustomField100] IS NOT NULL -- Users UPDATE [dbo].[TpUser] SET [FirstName] = 'FirstName' + CAST(UserID AS VARCHAR(10)), [LastName] = 'LastName' + CAST(UserID AS VARCHAR(10)), [Email] = 'Email' + CAST(UserID AS VARCHAR(10)) + '@web.com', [Login] = 'Login' + CAST(UserID AS VARCHAR(10)) + '@web.com', [SecretWord] = 'SecretWord' + CAST(UserID AS VARCHAR(10)), [ActiveDirectoryName] = 'ActiveDirectoryName' + CAST(UserID AS VARCHAR(10)), [Phone] = 'Phone' + CAST(UserID AS VARCHAR(10)), [Notes] = 'Notes' + CAST(UserID AS VARCHAR(10)); -- Email Messages UPDATE [dbo].[Message] SET [Subject] = 'Subject' + CAST(MEssageID AS VARCHAR(10)), [Recipients] = 'Email' + CAST(MEssageID AS VARCHAR(10)) + '@web.com', [body] = 'body' + CAST(MEssageID AS VARCHAR(10)); UPDATE [dbo].[MessageUid] SET [MailServer] = 'Server', [MailLogin] = 'Login'; UPDATE [dbo].[Project] SET SCPassword = '', InboundMailPassword= ''; DELETE FROM [dbo].[TpProfile] WHERE PropertyName LIKE '%InboundMailSettings'; -- Settings UPDATE [dbo].[PluginProfile] SET Settings = '', ProfileName = ''; UPDATE [dbo].[GlobalSetting] SET [CompanyName] = 'Company', [DisableHttpAccess] = 0, [SMTPServer] = 'Server', [SMTPLogin] = 'Login', [SMTPPassword] = 'Password'; UPDATE [dbo].[Tag] SET [Name] = 'Name' + CAST(TagID AS VARCHAR(10)); UPDATE [dbo].[AttachmentFile] SET [Buffer] = NULL; UPDATE [dbo].[Company] SET [CompanyName] = 'Company' + CAST(CompanyID AS VARCHAR(10)), [CompanyUrl] = 'http://' + CAST(CompanyID AS VARCHAR(10)); UPDATE [dbo].[Milestone] SET [Description] = 'Description' + CAST(MilestoneId AS VARCHAR(10)), [Name] = 'Name' + CAST(MilestoneId AS VARCHAR(10)); UPDATE [dbo].[Revision] SET [Description] = 'Description' + CAST(RevisionID AS VARCHAR(10)) UPDATE [dbo].[RevisionFile] SET [FileName] = '/file.txt' -- Custom fields UPDATE [dbo].[General] SET [CustomField1] = 'CustomField1' WHERE [CustomField1] IS NOT NULL UPDATE [dbo].[General] SET [CustomField2] = 'CustomField2' WHERE [CustomField2] IS NOT NULL UPDATE [dbo].[General] SET [CustomField3] = 'CustomField3' WHERE [CustomField3] IS NOT NULL UPDATE [dbo].[General] SET [CustomField4] = 'CustomField4' WHERE [CustomField4] IS NOT NULL UPDATE [dbo].[General] SET [CustomField5] = 'CustomField5' WHERE [CustomField5] IS NOT NULL UPDATE [dbo].[General] SET [CustomField6] = 'CustomField6' WHERE [CustomField6] IS NOT NULL UPDATE [dbo].[General] SET [CustomField7] = 'CustomField7' WHERE [CustomField7] IS NOT NULL UPDATE [dbo].[General] SET [CustomField8] = 'CustomField8' WHERE [CustomField8] IS NOT NULL UPDATE [dbo].[General] SET [CustomField9] = 'CustomField9' WHERE [CustomField9] IS NOT NULL UPDATE [dbo].[General] SET [CustomField10] = 'CustomField10' WHERE [CustomField10] IS NOT NULL UPDATE [dbo].[General] SET [CustomField11] = 'CustomField11' WHERE [CustomField11] IS NOT NULL UPDATE [dbo].[General] SET [CustomField12] = 'CustomField12' WHERE [CustomField12] IS NOT NULL UPDATE [dbo].[General] SET [CustomField13] = 'CustomField13' WHERE [CustomField13] IS NOT NULL UPDATE [dbo].[General] SET [CustomField14] = 'CustomField14' WHERE [CustomField14] IS NOT NULL UPDATE [dbo].[General] SET [CustomField15] = 'CustomField15' WHERE [CustomField15] IS NOT NULL UPDATE [dbo].[General] SET [CustomField16] = 'CustomField16' WHERE [CustomField16] IS NOT NULL UPDATE [dbo].[General] SET [CustomField17] = 'CustomField17' WHERE [CustomField17] IS NOT NULL UPDATE [dbo].[General] SET [CustomField18] = 'CustomField18' WHERE [CustomField18] IS NOT NULL UPDATE [dbo].[General] SET [CustomField19] = 'CustomField19' WHERE [CustomField19] IS NOT NULL UPDATE [dbo].[General] SET [CustomField20] = 'CustomField20' WHERE [CustomField20] IS NOT NULL UPDATE [dbo].[General] SET [CustomField21] = 'CustomField21' WHERE [CustomField21] IS NOT NULL UPDATE [dbo].[General] SET [CustomField22] = 'CustomField22' WHERE [CustomField22] IS NOT NULL UPDATE [dbo].[General] SET [CustomField23] = 'CustomField23' WHERE [CustomField23] IS NOT NULL UPDATE [dbo].[General] SET [CustomField24] = 'CustomField24' WHERE [CustomField24] IS NOT NULL UPDATE [dbo].[General] SET [CustomField25] = 'CustomField25' WHERE [CustomField25] IS NOT NULL UPDATE [dbo].[General] SET [CustomField26] = 'CustomField26' WHERE [CustomField26] IS NOT NULL UPDATE [dbo].[General] SET [CustomField27] = 'CustomField27' WHERE [CustomField27] IS NOT NULL UPDATE [dbo].[General] SET [CustomField28] = 'CustomField28' WHERE [CustomField28] IS NOT NULL UPDATE [dbo].[General] SET [CustomField29] = 'CustomField29' WHERE [CustomField29] IS NOT NULL UPDATE [dbo].[General] SET [CustomField30] = 'CustomField30' WHERE [CustomField30] IS NOT NULL UPDATE [dbo].[General] SET [CustomField31] = 'CustomField31' WHERE [CustomField31] IS NOT NULL UPDATE [dbo].[General] SET [CustomField32] = 'CustomField32' WHERE [CustomField32] IS NOT NULL UPDATE [dbo].[General] SET [CustomField33] = 'CustomField33' WHERE [CustomField33] IS NOT NULL UPDATE [dbo].[General] SET [CustomField34] = 'CustomField34' WHERE [CustomField34] IS NOT NULL UPDATE [dbo].[General] SET [CustomField35] = 'CustomField35' WHERE [CustomField35] IS NOT NULL UPDATE [dbo].[General] SET [CustomField36] = 'CustomField36' WHERE [CustomField36] IS NOT NULL UPDATE [dbo].[General] SET [CustomField37] = 'CustomField37' WHERE [CustomField37] IS NOT NULL UPDATE [dbo].[General] SET [CustomField38] = 'CustomField38' WHERE [CustomField38] IS NOT NULL UPDATE [dbo].[General] SET [CustomField39] = 'CustomField39' WHERE [CustomField39] IS NOT NULL UPDATE [dbo].[General] SET [CustomField40] = 'CustomField40' WHERE [CustomField40] IS NOT NULL UPDATE [dbo].[General] SET [CustomField41] = 'CustomField41' WHERE [CustomField41] IS NOT NULL UPDATE [dbo].[General] SET [CustomField42] = 'CustomField42' WHERE [CustomField42] IS NOT NULL UPDATE [dbo].[General] SET [CustomField43] = 'CustomField43' WHERE [CustomField43] IS NOT NULL UPDATE [dbo].[General] SET [CustomField44] = 'CustomField44' WHERE [CustomField44] IS NOT NULL UPDATE [dbo].[General] SET [CustomField45] = 'CustomField45' WHERE [CustomField45] IS NOT NULL UPDATE [dbo].[General] SET [CustomField46] = 'CustomField46' WHERE [CustomField46] IS NOT NULL UPDATE [dbo].[General] SET [CustomField47] = 'CustomField47' WHERE [CustomField47] IS NOT NULL UPDATE [dbo].[General] SET [CustomField48] = 'CustomField48' WHERE [CustomField48] IS NOT NULL UPDATE [dbo].[General] SET [CustomField49] = 'CustomField49' WHERE [CustomField49] IS NOT NULL UPDATE [dbo].[General] SET [CustomField50] = 'CustomField50' WHERE [CustomField50] IS NOT NULL UPDATE [dbo].[General] SET [CustomField51] = 'CustomField51' WHERE [CustomField51] IS NOT NULL UPDATE [dbo].[General] SET [CustomField52] = 'CustomField52' WHERE [CustomField52] IS NOT NULL UPDATE [dbo].[General] SET [CustomField53] = 'CustomField53' WHERE [CustomField53] IS NOT NULL UPDATE [dbo].[General] SET [CustomField54] = 'CustomField54' WHERE [CustomField54] IS NOT NULL UPDATE [dbo].[General] SET [CustomField55] = 'CustomField55' WHERE [CustomField55] IS NOT NULL UPDATE [dbo].[General] SET [CustomField56] = 'CustomField56' WHERE [CustomField56] IS NOT NULL UPDATE [dbo].[General] SET [CustomField57] = 'CustomField57' WHERE [CustomField57] IS NOT NULL UPDATE [dbo].[General] SET [CustomField58] = 'CustomField58' WHERE [CustomField58] IS NOT NULL UPDATE [dbo].[General] SET [CustomField59] = 'CustomField59' WHERE [CustomField59] IS NOT NULL UPDATE [dbo].[General] SET [CustomField60] = 'CustomField60' WHERE [CustomField60] IS NOT NULL UPDATE [dbo].[General] SET [CustomField61] = 'CustomField61' WHERE [CustomField61] IS NOT NULL UPDATE [dbo].[General] SET [CustomField62] = 'CustomField62' WHERE [CustomField62] IS NOT NULL UPDATE [dbo].[General] SET [CustomField63] = 'CustomField63' WHERE [CustomField63] IS NOT NULL UPDATE [dbo].[General] SET [CustomField64] = 'CustomField64' WHERE [CustomField64] IS NOT NULL UPDATE [dbo].[General] SET [CustomField65] = 'CustomField65' WHERE [CustomField65] IS NOT NULL UPDATE [dbo].[General] SET [CustomField66] = 'CustomField66' WHERE [CustomField66] IS NOT NULL UPDATE [dbo].[General] SET [CustomField67] = 'CustomField67' WHERE [CustomField67] IS NOT NULL UPDATE [dbo].[General] SET [CustomField68] = 'CustomField68' WHERE [CustomField68] IS NOT NULL UPDATE [dbo].[General] SET [CustomField69] = 'CustomField69' WHERE [CustomField69] IS NOT NULL UPDATE [dbo].[General] SET [CustomField70] = 'CustomField70' WHERE [CustomField70] IS NOT NULL UPDATE [dbo].[General] SET [CustomField71] = 'CustomField71' WHERE [CustomField71] IS NOT NULL UPDATE [dbo].[General] SET [CustomField72] = 'CustomField72' WHERE [CustomField72] IS NOT NULL UPDATE [dbo].[General] SET [CustomField73] = 'CustomField73' WHERE [CustomField73] IS NOT NULL UPDATE [dbo].[General] SET [CustomField74] = 'CustomField74' WHERE [CustomField74] IS NOT NULL UPDATE [dbo].[General] SET [CustomField75] = 'CustomField75' WHERE [CustomField75] IS NOT NULL UPDATE [dbo].[General] SET [CustomField76] = 'CustomField76' WHERE [CustomField76] IS NOT NULL UPDATE [dbo].[General] SET [CustomField77] = 'CustomField77' WHERE [CustomField77] IS NOT NULL UPDATE [dbo].[General] SET [CustomField78] = 'CustomField78' WHERE [CustomField78] IS NOT NULL UPDATE [dbo].[General] SET [CustomField79] = 'CustomField79' WHERE [CustomField79] IS NOT NULL UPDATE [dbo].[General] SET [CustomField80] = 'CustomField80' WHERE [CustomField80] IS NOT NULL UPDATE [dbo].[General] SET [CustomField81] = 'CustomField81' WHERE [CustomField81] IS NOT NULL UPDATE [dbo].[General] SET [CustomField82] = 'CustomField82' WHERE [CustomField82] IS NOT NULL UPDATE [dbo].[General] SET [CustomField83] = 'CustomField83' WHERE [CustomField83] IS NOT NULL UPDATE [dbo].[General] SET [CustomField84] = 'CustomField84' WHERE [CustomField84] IS NOT NULL UPDATE [dbo].[General] SET [CustomField85] = 'CustomField85' WHERE [CustomField85] IS NOT NULL UPDATE [dbo].[General] SET [CustomField86] = 'CustomField86' WHERE [CustomField86] IS NOT NULL UPDATE [dbo].[General] SET [CustomField87] = 'CustomField87' WHERE [CustomField87] IS NOT NULL UPDATE [dbo].[General] SET [CustomField88] = 'CustomField88' WHERE [CustomField88] IS NOT NULL UPDATE [dbo].[General] SET [CustomField89] = 'CustomField89' WHERE [CustomField89] IS NOT NULL UPDATE [dbo].[General] SET [CustomField90] = 'CustomField90' WHERE [CustomField90] IS NOT NULL UPDATE [dbo].[General] SET [CustomField91] = 'CustomField91' WHERE [CustomField91] IS NOT NULL UPDATE [dbo].[General] SET [CustomField92] = 'CustomField92' WHERE [CustomField92] IS NOT NULL UPDATE [dbo].[General] SET [CustomField93] = 'CustomField93' WHERE [CustomField93] IS NOT NULL UPDATE [dbo].[General] SET [CustomField94] = 'CustomField94' WHERE [CustomField94] IS NOT NULL UPDATE [dbo].[General] SET [CustomField95] = 'CustomField95' WHERE [CustomField95] IS NOT NULL UPDATE [dbo].[General] SET [CustomField96] = 'CustomField96' WHERE [CustomField96] IS NOT NULL UPDATE [dbo].[General] SET [CustomField97] = 'CustomField97' WHERE [CustomField97] IS NOT NULL UPDATE [dbo].[General] SET [CustomField98] = 'CustomField98' WHERE [CustomField98] IS NOT NULL UPDATE [dbo].[General] SET [CustomField99] = 'CustomField99' WHERE [CustomField99] IS NOT NULL UPDATE [dbo].[General] SET [CustomField100] = 'CustomField100' WHERE [CustomField100] IS NOT NULL EXEC enableTriggers;