UPDATE [STORAGE] SET [Path]=REPLACE([Path],'\\SERVER1','\\SERVER2'); GO