surunt
SSC Rookie
Points: 40
More actions
April 23, 2008 at 2:28 am
#76965
HI
can i execute the Dos commands in Stored Procedure
Give me an example. . .
Rgds
Suresh
steveb.
SSC-Forever
Points: 46733
April 23, 2008 at 2:49 am
#805923
you can, but you need to have specific access to the command
xp_cmdshell
EXEC xp_cmdshell 'Dir C:\*.*'
Sergiy
SSC Guru
Points: 110208
April 23, 2008 at 3:02 am
#805929
Will not work from user databases.
Should be
EXEC master..xp_cmdshell 'Dir C:\*.*'
_____________Code for TallyGenerator
April 23, 2008 at 3:05 am
#805933
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply