Is there really no one who can reproduce my issue !?!?

Hi, thanks for quick answer.

@@ServerName = SQL01 (same as physical servername)

Yes, its possible to connect via IP (local and from remote machine).

It seems that there runs no processes on local...

My Mistake!! The statements are not copy & pasted correctly by me.

Here a better Version:

DECLARE @Cmd VARCHAR(4000)

SET @Cmd = ' "C:\WINDOWS\system32\windowspowershell\v1.0\powershell" "& Get-Process " '

PRINT @Cmd

exec master..xp_cmdshell @Cmd

SET @Cmd =...

No ideas??

I found the same question here: http://www.sqlreportingservices.net/Ask/6509.aspx

But there is no solution too.

Daniel

I agree with Jan.

Regards

Daniel

Try this in Management Studio:

CREATE TABLE #tbPersonalDetails(

PK_ID INT NOT NULL PRIMARY KEY,

[Name] NVARCHAR(50) NOT NULL,

Married BIT NOT NULL,

DOB SMALLDATETIME NOT NULL,

BachelorsDegree BIT NOT NULL,

MastersDegree BIT NOT NULL,

Profession NVARCHAR(100) NOT NULL,

Retired...