-- =============================================
-- Author:		<Gjoreski Aleksandar>
-- Create date: <09.07.2021 13:42:21>
-- Description:	<Stored Procedura za kreirajne na direktoriom (Folder) > 
-- =============================================
ALTER PROCEDURE [dbo].[spCreate_FTP_Folder]
         ( @Folder AS NVARCHAR(30))
AS
BEGIN
        SET @Folder='MD C:\FTP_Doc\' + CONVERT(NVARCHAR,@Folder)
        EXEC sp_configure 'xp_cmdshell', '1' 
        RECONFIGURE
        EXEC xp_cmdshell @Folder
        EXEC sp_configure 'xp_cmdshell', '0' 
        RECONFIGURE

END