>You could use this object as in any other language.
>Just keep in mind that OLE Automation is forbidden by default in SQL Server 2005 and 2008.
>
>
Yes, I figured this out as much. What is the name of the other sp (exec cmdshell)? I forgot for a moment.


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