views:

32

answers:

0

Ok, so I am trying to create a procedure that call an extended procedure. I am getting the following error:

Msg 121, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

Even with the simplest test I get that error:

CREATE PROCEDURE Test
AS
BEGIN

EXEC xp_cmdshell 'dir *.exe'

END

However if I just run xp_cmdshell 'dir *.exe' by itself it works.

This is running on a clustered SQL 2005 server. Any help is appreciated.