Can we use this to create a new directory from SQL Server? What are limitations of this technique?

I'm sorry, I can not test this at this moment.

>Here's another way using WSH

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
>

>>
>>I am trying to determine if a folder exist on my server.
>>If the folder exist I would like to rename it.
>>
>>I know I can use the xp_fileexist extended procedure but I do not know how to determined if it is a folder.
>>