What is the proper process for changing Call Ticket attachment paths?

Version 1

    Details

    What is the proper process for changing Call Ticket attachment paths?


    Resolution

    --Only values that need to be changed are the --\\ORIGINAL_SERVER_NAME\Attachment_Folder','\\NEW_SERVER_NAME\Attachment_Folder'  --Copy and paste everything below this line into a new query in Management Studio replacing the old path with the new path.--  SELECT GName, gdetail   FROM dbo.HEATGen  where GCode not in ('at','ap')   DECLARE Heat_cursor  CURSOR FOR  SELECT Gname, GDetail  FROM dbo.HEATgen   DECLARE @Gname AS VARCHAR(10)  DECLARE @GDetail AS VARCHAR(8000)  DECLARE @GDetail_Temp AS VARCHAR(8000)   OPEN Heat_cursor  FETCH FROM Heat_cursor INTO @Gname, @GDetail  WHILE @@fetch_status = 0  BEGIN        SELECT @GDetail_Temp = REPLACE(@GDetail,'\\ORIGINAL_SERVER_NAME\Attachment_Folder','\\NEW_SERVER_NAME\Attachment_Folder')           UPDATE dbo.HEATGen SET GDetail = @GDetail_Temp WHERE CURRENT OF Heat_cursor        FETCH next from Heat_cursor INTO @Gname, @GDetail    END    CLOSE Heat_cursor  DEALLOCATE Heat_cursor