April 23, 2008 at 2:28 am
HI
can i execute the Dos commands in Stored Procedure
Give me an example. . .
Rgds
Suresh
April 23, 2008 at 2:49 am
you can, but you need to have specific access to the command
xp_cmdshell
EXEC xp_cmdshell 'Dir C:\*.*'
April 23, 2008 at 3:02 am
Will not work from user databases.
Should be
EXEC master..xp_cmdshell 'Dir C:\*.*'
_____________
Code for TallyGenerator
April 23, 2008 at 3:05 am
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy