DECLARE @RetVal int, @FSO int, @hr int, @Folder int DECLARE @FolderName varchar(256), @NewFolderName varchar(256) SET @FolderName = 'H:\tmp\Klm' SET @NewFolderName = 'NewName' EXEC @hr = sp_OACreate 'Scripting.FileSystemObject', @FSO OUT EXEC @hr = sp_OAMethod @FSO, 'FolderExists', @RetVal OUT, @FolderName IF @RetVal <> 0 BEGIN EXEC @hr = sp_OAMethod @FSO, 'GetFolder', @Folder OUT, @FolderName IF @hr = 0 EXEC @hr = sp_OASetProperty @Folder, 'Name', @NewFolderName END EXEC @hr = sp_OADestroy @FSO>