sp_configure 'show advanced options',1go reconfigure with overridegosp_configure 'Ole Automation Procedures',1goreconfigure  with overridegoALTER PROC dbo.usp_OACreate  @folderName VARCHAR(256)='C:\Test\testfa'ASBEGIN 	DECLARE @hr INT,@fso_token INT,@dirHandle INT,@IsDir_flag BIT,@IsParDirExists_Flag BIT	DECLARE @tempTab TABLE(fileexists_flag BIT,IsDir_flag BIT,IsParDirExists_Flag BIT)	INSERT INTO @tempTab	EXEC xp_fileexist @folderName  --,@hr output	SELECT @IsDir_flag=IsDir_flag,@IsParDirExists_Flag=IsParDirExists_Flag FROM @tempTab	IF @IsDir_flag<>1 AND @IsParDirExists_Flag=1		BEGIN		     EXEC @hr=SP_OACREATE 'Scripting.FileSystemObject',@fso_token OUTPUT			  IF @hr<>0				BEGIN					GOTO errorProcess				END				ELSE					BEGIN						EXEC @hr=SP_OAMethod @fso_token,'CreateFolder',@dirHandle OUTPUT,@folderName					    					    IF @hr<>0 GOTO errorProcess						ELSE 						 EXEC SP_OADestroy @fso_token					END		END	ELSE	GOTO fileexists	errorProcess:	EXEC SP_OAGetErrorInfo @fso_token	RETURN 1; --- FAILED	fileexists:	RAISERROR('Folder %s exists OR its parent directory path is not exist!!! please check!!!',-1,-1,@folderName) WITH NOWAITENDGO