Dear Friends we can use command of command prompt in sqlserver
use xp_cmdshell for fire batching command
Like
EXEC xp_cmdshell '
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
Kunal VaishyaPosted Jul 4, 2012, 5:53 AM
its very use full if any command base programing in SqlServer