Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-23 : 09:24:49
|
| chris briosos writes "how can i execute a xp_cmdshell in a stored procude???here's my sample stored procedure:---------------CREATE PROCEDURE test ASexecute xp_cmdshell '\\chris\files\dirw.bat'---------------i cannot run it in query analyzer and its error is:---------------Server: Msg 2812, Level 16, State 62, Line 3Could not find stored procedure 'xp_cmdshell'.---------------but when i just run the script in query analyzer like this---------------use masterexecute xp_cmdshell '\\chris\files\dirw.bat'---------------the script runned.can you help me on this... thanks..." |
|
|
|
|
|
execute xp_cmdshell in a stored procedure