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 |
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2007-07-10 : 06:16:21
|
| i am getting followig error while using xp_cmdshellcan anyone help regarding thisMessageDescription: [SQL-DMO]The name 'SPS90HFD1D\SQLServer2005MSFTEUser$RAJServer$MSSQL' was not found in the Users collection. If the name is a qualified name, use [] to separate various parts of the name, and try again. [SQLSTATE 01000] (Message 0) An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '1455'. [SQLSTATE 42000] (Error 15121). The step failed. |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-07-10 : 06:20:45
|
| can u post the full code to understand better. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-10 : 10:45:25
|
| Did you enable xp_cmdshell in surface area configuration? |
 |
|
|
rajkumarrai_bis
Yak Posting Veteran
78 Posts |
Posted - 2007-07-11 : 00:42:45
|
| xp_cmdshell is used to create directories following is the codeexec master..xp_cmdshell 'mkdir DirectoryName'this code was running fine till nowhowever it is again running fine after I restarted the SQl Server |
 |
|
|
|
|
|