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 |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2007-10-16 : 05:44:14
|
| In SQL Server 2005, once in a while, the xp_cmdshell gives thefollowing error."An error occurred during the execution of xp_cmdshell. A call to'CreateProcess' failed with error code: '5'. [SQLSTATE 42000] (Error15121). The step failed.".Does Looping has a limitation on the number of times it can call xp_cmdshell.It works good whenever we call it individually. Thanks in AdvanceRKNAIR |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-16 : 06:18:47
|
Where?In SSMS or SSIS?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-10-16 : 06:26:21
|
| SSMS only....RKNAIR |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-18 : 23:37:57
|
| Applied any sql2k5 sp? |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-10-19 : 06:27:52
|
| Can you please tell me how to check the service pack installed.....RKNAIR |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-10-19 : 09:58:23
|
| Its SP2 dude...RKNAIR |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-19 : 10:09:40
|
Check you system event log for errors, it could be a drive problem.Error 5 is access denied, 15121 can be an invalid path so either you have a permission issue or the some sort of issue perhaps with a drive becoming unavailable intermittently. Or, possible a bug, can you provide some more detail on what you are calling with the cmdshell?
Future guru in the making. |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-10-19 : 14:13:40
|
| It happened when tried to execute a job.RKNAIR |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-19 : 23:21:18
|
| Can you post more details of the job? |
|
|
|
|
|
|
xp_cmdshell