EXEC disableTriggers

DECLARE @oldPath NVARCHAR(255);
DECLARE @newPath NVARCHAR(255);

SET @oldPath = 'my.tpondemand.com';
SET @newPath = 'localhost/Targetprocess2';

DECLARE @oldPathEncoded NVARCHAR(255) = '/' + @oldPath + '/';
DECLARE @newPathEncoded NVARCHAR(255) = '/' + REPLACE(@newPath, '/', '/') + '/';

SET @oldPathEncoded = '/' + @oldPath + '/';
SET @newPathEncoded = '/' + REPLACE(@newPath, '/', '/') + '/';

--UPDATE ENCODED FIRST

UPDATE [dbo].[General] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[General] SET [CustomField1] = REPLACE([CustomField1], @oldPathEncoded, @newPathEncoded) WHERE [CustomField1] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField2] = REPLACE([CustomField2], @oldPathEncoded, @newPathEncoded) WHERE [CustomField2] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField3] = REPLACE([CustomField3], @oldPathEncoded, @newPathEncoded) WHERE [CustomField3] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField4] = REPLACE([CustomField4], @oldPathEncoded, @newPathEncoded) WHERE [CustomField4] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField5] = REPLACE([CustomField5], @oldPathEncoded, @newPathEncoded) WHERE [CustomField5] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField6] = REPLACE([CustomField6], @oldPathEncoded, @newPathEncoded) WHERE [CustomField6] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField7] = REPLACE([CustomField7], @oldPathEncoded, @newPathEncoded) WHERE [CustomField7] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField8] = REPLACE([CustomField8], @oldPathEncoded, @newPathEncoded) WHERE [CustomField8] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField9] = REPLACE([CustomField9], @oldPathEncoded, @newPathEncoded) WHERE [CustomField9] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField10] = REPLACE([CustomField10], @oldPathEncoded, @newPathEncoded) WHERE [CustomField10] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField11] = REPLACE([CustomField11], @oldPathEncoded, @newPathEncoded) WHERE [CustomField11] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField12] = REPLACE([CustomField12], @oldPathEncoded, @newPathEncoded) WHERE [CustomField12] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField13] = REPLACE([CustomField13], @oldPathEncoded, @newPathEncoded) WHERE [CustomField13] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField14] = REPLACE([CustomField14], @oldPathEncoded, @newPathEncoded) WHERE [CustomField14] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField15] = REPLACE([CustomField15], @oldPathEncoded, @newPathEncoded) WHERE [CustomField15] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField16] = REPLACE([CustomField16], @oldPathEncoded, @newPathEncoded) WHERE [CustomField16] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField17] = REPLACE([CustomField17], @oldPathEncoded, @newPathEncoded) WHERE [CustomField17] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField18] = REPLACE([CustomField18], @oldPathEncoded, @newPathEncoded) WHERE [CustomField18] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField19] = REPLACE([CustomField19], @oldPathEncoded, @newPathEncoded) WHERE [CustomField19] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField20] = REPLACE([CustomField20], @oldPathEncoded, @newPathEncoded) WHERE [CustomField20] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField21] = REPLACE([CustomField21], @oldPathEncoded, @newPathEncoded) WHERE [CustomField21] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField22] = REPLACE([CustomField22], @oldPathEncoded, @newPathEncoded) WHERE [CustomField22] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField23] = REPLACE([CustomField23], @oldPathEncoded, @newPathEncoded) WHERE [CustomField23] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField24] = REPLACE([CustomField24], @oldPathEncoded, @newPathEncoded) WHERE [CustomField24] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField25] = REPLACE([CustomField25], @oldPathEncoded, @newPathEncoded) WHERE [CustomField25] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField26] = REPLACE([CustomField26], @oldPathEncoded, @newPathEncoded) WHERE [CustomField26] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField27] = REPLACE([CustomField27], @oldPathEncoded, @newPathEncoded) WHERE [CustomField27] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField28] = REPLACE([CustomField28], @oldPathEncoded, @newPathEncoded) WHERE [CustomField28] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField29] = REPLACE([CustomField29], @oldPathEncoded, @newPathEncoded) WHERE [CustomField29] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField30] = REPLACE([CustomField30], @oldPathEncoded, @newPathEncoded) WHERE [CustomField30] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField31] = REPLACE([CustomField31], @oldPathEncoded, @newPathEncoded) WHERE [CustomField31] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField32] = REPLACE([CustomField32], @oldPathEncoded, @newPathEncoded) WHERE [CustomField32] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField33] = REPLACE([CustomField33], @oldPathEncoded, @newPathEncoded) WHERE [CustomField33] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField34] = REPLACE([CustomField34], @oldPathEncoded, @newPathEncoded) WHERE [CustomField34] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField35] = REPLACE([CustomField35], @oldPathEncoded, @newPathEncoded) WHERE [CustomField35] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField36] = REPLACE([CustomField36], @oldPathEncoded, @newPathEncoded) WHERE [CustomField36] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField37] = REPLACE([CustomField37], @oldPathEncoded, @newPathEncoded) WHERE [CustomField37] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField38] = REPLACE([CustomField38], @oldPathEncoded, @newPathEncoded) WHERE [CustomField38] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField39] = REPLACE([CustomField39], @oldPathEncoded, @newPathEncoded) WHERE [CustomField39] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField40] = REPLACE([CustomField40], @oldPathEncoded, @newPathEncoded) WHERE [CustomField40] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField41] = REPLACE([CustomField41], @oldPathEncoded, @newPathEncoded) WHERE [CustomField41] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField42] = REPLACE([CustomField42], @oldPathEncoded, @newPathEncoded) WHERE [CustomField42] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField43] = REPLACE([CustomField43], @oldPathEncoded, @newPathEncoded) WHERE [CustomField43] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField44] = REPLACE([CustomField44], @oldPathEncoded, @newPathEncoded) WHERE [CustomField44] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField45] = REPLACE([CustomField45], @oldPathEncoded, @newPathEncoded) WHERE [CustomField45] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField46] = REPLACE([CustomField46], @oldPathEncoded, @newPathEncoded) WHERE [CustomField46] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField47] = REPLACE([CustomField47], @oldPathEncoded, @newPathEncoded) WHERE [CustomField47] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField48] = REPLACE([CustomField48], @oldPathEncoded, @newPathEncoded) WHERE [CustomField48] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField49] = REPLACE([CustomField49], @oldPathEncoded, @newPathEncoded) WHERE [CustomField49] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField50] = REPLACE([CustomField50], @oldPathEncoded, @newPathEncoded) WHERE [CustomField50] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField51] = REPLACE([CustomField51], @oldPathEncoded, @newPathEncoded) WHERE [CustomField51] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField52] = REPLACE([CustomField52], @oldPathEncoded, @newPathEncoded) WHERE [CustomField52] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField53] = REPLACE([CustomField53], @oldPathEncoded, @newPathEncoded) WHERE [CustomField53] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField54] = REPLACE([CustomField54], @oldPathEncoded, @newPathEncoded) WHERE [CustomField54] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField55] = REPLACE([CustomField55], @oldPathEncoded, @newPathEncoded) WHERE [CustomField55] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField56] = REPLACE([CustomField56], @oldPathEncoded, @newPathEncoded) WHERE [CustomField56] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField57] = REPLACE([CustomField57], @oldPathEncoded, @newPathEncoded) WHERE [CustomField57] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField58] = REPLACE([CustomField58], @oldPathEncoded, @newPathEncoded) WHERE [CustomField58] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField59] = REPLACE([CustomField59], @oldPathEncoded, @newPathEncoded) WHERE [CustomField59] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField60] = REPLACE([CustomField60], @oldPathEncoded, @newPathEncoded) WHERE [CustomField60] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[Comment] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[TestCase] SET [Steps] = CAST(REPLACE(CAST([Steps] AS NVarchar(MAX)), @oldPathEncoded, @newPathEncoded) AS NText) WHERE [Steps] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[TestCase] SET [Success] = CAST(REPLACE(CAST([Success] AS NVarchar(MAX)), @oldPathEncoded, @newPathEncoded) AS NText) WHERE [Success] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[TestCase] SET [LastFailureComment] = REPLACE([LastFailureComment], @oldPathEncoded, @newPathEncoded) WHERE [LastFailureComment] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[TestCaseRun] SET [Comment] = REPLACE([Comment], @oldPathEncoded, @newPathEncoded) WHERE [Comment] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[TestStep] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[TestStep] SET [Result] = REPLACE([Result], @oldPathEncoded, @newPathEncoded) WHERE [Result] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[FreezedTestCaseInfo] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[FreezedTestStepInfo] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

--UPDATE DECODED

SET @oldPathEncoded = '/' + @oldPath + '/';
SET @newPathEncoded = '/' + @newPath + '/';

UPDATE [dbo].[General] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[General] SET [CustomField1] = REPLACE([CustomField1], @oldPathEncoded, @newPathEncoded) WHERE [CustomField1] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField2] = REPLACE([CustomField2], @oldPathEncoded, @newPathEncoded) WHERE [CustomField2] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField3] = REPLACE([CustomField3], @oldPathEncoded, @newPathEncoded) WHERE [CustomField3] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField4] = REPLACE([CustomField4], @oldPathEncoded, @newPathEncoded) WHERE [CustomField4] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField5] = REPLACE([CustomField5], @oldPathEncoded, @newPathEncoded) WHERE [CustomField5] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField6] = REPLACE([CustomField6], @oldPathEncoded, @newPathEncoded) WHERE [CustomField6] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField7] = REPLACE([CustomField7], @oldPathEncoded, @newPathEncoded) WHERE [CustomField7] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField8] = REPLACE([CustomField8], @oldPathEncoded, @newPathEncoded) WHERE [CustomField8] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField9] = REPLACE([CustomField9], @oldPathEncoded, @newPathEncoded) WHERE [CustomField9] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField10] = REPLACE([CustomField10], @oldPathEncoded, @newPathEncoded) WHERE [CustomField10] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField11] = REPLACE([CustomField11], @oldPathEncoded, @newPathEncoded) WHERE [CustomField11] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField12] = REPLACE([CustomField12], @oldPathEncoded, @newPathEncoded) WHERE [CustomField12] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField13] = REPLACE([CustomField13], @oldPathEncoded, @newPathEncoded) WHERE [CustomField13] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField14] = REPLACE([CustomField14], @oldPathEncoded, @newPathEncoded) WHERE [CustomField14] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField15] = REPLACE([CustomField15], @oldPathEncoded, @newPathEncoded) WHERE [CustomField15] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField16] = REPLACE([CustomField16], @oldPathEncoded, @newPathEncoded) WHERE [CustomField16] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField17] = REPLACE([CustomField17], @oldPathEncoded, @newPathEncoded) WHERE [CustomField17] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField18] = REPLACE([CustomField18], @oldPathEncoded, @newPathEncoded) WHERE [CustomField18] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField19] = REPLACE([CustomField19], @oldPathEncoded, @newPathEncoded) WHERE [CustomField19] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField20] = REPLACE([CustomField20], @oldPathEncoded, @newPathEncoded) WHERE [CustomField20] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField21] = REPLACE([CustomField21], @oldPathEncoded, @newPathEncoded) WHERE [CustomField21] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField22] = REPLACE([CustomField22], @oldPathEncoded, @newPathEncoded) WHERE [CustomField22] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField23] = REPLACE([CustomField23], @oldPathEncoded, @newPathEncoded) WHERE [CustomField23] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField24] = REPLACE([CustomField24], @oldPathEncoded, @newPathEncoded) WHERE [CustomField24] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField25] = REPLACE([CustomField25], @oldPathEncoded, @newPathEncoded) WHERE [CustomField25] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField26] = REPLACE([CustomField26], @oldPathEncoded, @newPathEncoded) WHERE [CustomField26] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField27] = REPLACE([CustomField27], @oldPathEncoded, @newPathEncoded) WHERE [CustomField27] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField28] = REPLACE([CustomField28], @oldPathEncoded, @newPathEncoded) WHERE [CustomField28] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField29] = REPLACE([CustomField29], @oldPathEncoded, @newPathEncoded) WHERE [CustomField29] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField30] = REPLACE([CustomField30], @oldPathEncoded, @newPathEncoded) WHERE [CustomField30] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField31] = REPLACE([CustomField31], @oldPathEncoded, @newPathEncoded) WHERE [CustomField31] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField32] = REPLACE([CustomField32], @oldPathEncoded, @newPathEncoded) WHERE [CustomField32] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField33] = REPLACE([CustomField33], @oldPathEncoded, @newPathEncoded) WHERE [CustomField33] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField34] = REPLACE([CustomField34], @oldPathEncoded, @newPathEncoded) WHERE [CustomField34] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField35] = REPLACE([CustomField35], @oldPathEncoded, @newPathEncoded) WHERE [CustomField35] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField36] = REPLACE([CustomField36], @oldPathEncoded, @newPathEncoded) WHERE [CustomField36] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField37] = REPLACE([CustomField37], @oldPathEncoded, @newPathEncoded) WHERE [CustomField37] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField38] = REPLACE([CustomField38], @oldPathEncoded, @newPathEncoded) WHERE [CustomField38] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField39] = REPLACE([CustomField39], @oldPathEncoded, @newPathEncoded) WHERE [CustomField39] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField40] = REPLACE([CustomField40], @oldPathEncoded, @newPathEncoded) WHERE [CustomField40] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField41] = REPLACE([CustomField41], @oldPathEncoded, @newPathEncoded) WHERE [CustomField41] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField42] = REPLACE([CustomField42], @oldPathEncoded, @newPathEncoded) WHERE [CustomField42] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField43] = REPLACE([CustomField43], @oldPathEncoded, @newPathEncoded) WHERE [CustomField43] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField44] = REPLACE([CustomField44], @oldPathEncoded, @newPathEncoded) WHERE [CustomField44] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField45] = REPLACE([CustomField45], @oldPathEncoded, @newPathEncoded) WHERE [CustomField45] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField46] = REPLACE([CustomField46], @oldPathEncoded, @newPathEncoded) WHERE [CustomField46] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField47] = REPLACE([CustomField47], @oldPathEncoded, @newPathEncoded) WHERE [CustomField47] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField48] = REPLACE([CustomField48], @oldPathEncoded, @newPathEncoded) WHERE [CustomField48] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField49] = REPLACE([CustomField49], @oldPathEncoded, @newPathEncoded) WHERE [CustomField49] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField50] = REPLACE([CustomField50], @oldPathEncoded, @newPathEncoded) WHERE [CustomField50] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField51] = REPLACE([CustomField51], @oldPathEncoded, @newPathEncoded) WHERE [CustomField51] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField52] = REPLACE([CustomField52], @oldPathEncoded, @newPathEncoded) WHERE [CustomField52] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField53] = REPLACE([CustomField53], @oldPathEncoded, @newPathEncoded) WHERE [CustomField53] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField54] = REPLACE([CustomField54], @oldPathEncoded, @newPathEncoded) WHERE [CustomField54] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField55] = REPLACE([CustomField55], @oldPathEncoded, @newPathEncoded) WHERE [CustomField55] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField56] = REPLACE([CustomField56], @oldPathEncoded, @newPathEncoded) WHERE [CustomField56] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField57] = REPLACE([CustomField57], @oldPathEncoded, @newPathEncoded) WHERE [CustomField57] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField58] = REPLACE([CustomField58], @oldPathEncoded, @newPathEncoded) WHERE [CustomField58] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField59] = REPLACE([CustomField59], @oldPathEncoded, @newPathEncoded) WHERE [CustomField59] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[General] SET [CustomField60] = REPLACE([CustomField60], @oldPathEncoded, @newPathEncoded) WHERE [CustomField60] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[Comment] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[TestCase] SET [Steps] = CAST(REPLACE(CAST([Steps] AS NVarchar(MAX)), @oldPathEncoded, @newPathEncoded) AS NText) WHERE [Steps] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[TestCase] SET [Success] = CAST(REPLACE(CAST([Success] AS NVarchar(MAX)), @oldPathEncoded, @newPathEncoded) AS NText) WHERE [Success] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[TestCase] SET [LastFailureComment] = REPLACE([LastFailureComment], @oldPathEncoded, @newPathEncoded) WHERE [LastFailureComment] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[TestCaseRun] SET [Comment] = REPLACE([Comment], @oldPathEncoded, @newPathEncoded) WHERE [Comment] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[TestStep] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';
UPDATE [dbo].[TestStep] SET [Result] = REPLACE([Result], @oldPathEncoded, @newPathEncoded) WHERE [Result] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[FreezedTestCaseInfo] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

UPDATE [dbo].[FreezedTestStepInfo] SET [Description] = REPLACE([Description], @oldPathEncoded, @newPathEncoded) WHERE [Description] like '%' + @oldPathEncoded + '%';

EXEC enableTriggers