create a folder in a file server using xp_create_subdir
-
In VS I called master.sys.xp_create_subdir @dir to create a folder on a file server, it is successful, but I called my own sp that includes this built-in sp, it is error out and the message is ';Error executing extended stored procedure: Invalid Parameter';, can anyone tell me what the problem is, how should I fix it? Here is the code create procedure usp_MyProcedure as declare @dir varchar(50) set @dir = '\\servername\folder\subfolder\' exec master.sys.xp_create_subdir @dir go Thank you for your help in advance
-
In VS I called master.sys.xp_create_subdir @dir to create a folder on a file server, it is successful, but I called my own sp that includes this built-in sp, it is error out and the message is ';Error executing extended stored procedure: Invalid Parameter';, can anyone tell me what the problem is, how should I fix it? Here is the code create procedure usp_MyProcedure as declare @dir varchar(50) set @dir = '\\servername\folder\subfolder\' exec master.sys.xp_create_subdir @dir go Thank you for your help in advance
This will be a permissions issue. Your executing sp doors not have permission to use master system procedures
Never underestimate the power of human stupidity RAH