Search results for query: *

Hi - I'm running SS2005 on 2003. I'm tring to use xp_cmdshell to run 'taskkill' to kill a process. I keep getting 'Access denied'. The SQL account that is running xp_cmdshell is in the server admin group. If I log on using that account I can kill the process using command prompt. Interestingly...

...deadlocks weren't included in the trace, but the delay is occuring after the commit is made. There is no activity on the db...

...final attempt to get to the bottom of this one... ran trace, set sql agent to trace messages, created output file for CmdExec... result : i) CmdExec log file empty ii) No mention of 'failure' in sql server agent logs iii) trace file shows transaction commited and logout, then sits there with...

...although I managed to spell it wrong, the failure is intermittent... when it is successfull the agent log states : Executed as user: 'x'. The step did not generate any output. Process Exit Code 0. The step succeeded. On the trace file the log update happens immediately after the commit is...

Hi denny - it's not the exe. Exe is doing exactly what it should and issue only arises if run via job agent. Problem is that once trans are committed 'nothing happens' for a while and then job agent logs an error. The exe has it's own log file. Log file says it ran successfully and finished at...

Hi - I have a job that contains a step that runs a CmdExec. The CmdExec is running an exe that imports data from a csv into the db. The job regularly fails with : 'The step did not generate any output. Process Exit Code -1073741819. The step failed.' I have a run a trace and I can a lot of...

No worries, sorted.

Hi all. I have a main form that after a click event I change the mousepointer to an hourglass and then load up another form which contains a custom control (an XML Combo box). When running in debug all works OK - the mousepointer reverts to vbDefault with no problems. But when in run-time, the...