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 >>>