Create Directory Using SqlServer


Dear Friends we can use command of command prompt in sqlserver

use
xp_cmdshell for fire batching command

Like

EXEC xp_cmdshell 'Command String'


EXEC xp_cmdshell 'dir *.exe'


to get all directory information

EXEC xp_cmdshell 'mkdir kunal'

to Create New Directory is deafult path system32 you can set