These views are filtered views based on the tables and tables contains all more info. If I give access to the table then user will be able to see all...

Please ignore the previous message. This is being fixed by using following stored procedure.

DECLARE @instance_id int;

SELECT @instance_id = mi.instance_id

FROM msdb.dbo.sysutility_ucp_managed_instances AS mi

WHERE mi.instance_name = 'ComputerName\InstanceName';

EXEC msdb.dbo.sp_sysutility_ucp_remove_mi @instance_id;

EXEC msdb.dbo.sp_sysutility_mi_remove;

No problem.. Thanks for your help.

Yes, I did all that.

Thanks Jeff for the script.. I ran the script but still getting the same error.

A call to 'CreateProcessAsUser' failed with error code: '1314'.

I am sure that this error related to...

Thanks Jeff,

How about doing like this ?

CREATE PROCEDURE dbo.usp_ExecCmdShellProcess

AS

BEGIN

DECLARE @job NVARCHAR(100) ;

...

Actually, this is part I am still working on.. Thanks a lot..

Yes, I did.

Looks like to me that some group policy is setup on this box to restricted xp_cmdshell.

Hi Steve,

I have not setup the proxy because in our environment xp_cmdshell command is used by lots of stored procedure so setting up credentials is enough. Correct me if I...

I tried same here but getting an error. I think this is something related to security policy..

USE master

GO

-- Create the SQL login which will use xp_cmdshell.

CREATE LOGIN CmdShellUser WITH PASSWORD='123'

--...

When I run the batch file. it works fine. I have stored Oracle username and password in the ssis config file and works fine but when I use xp_cmdshell command...

Yes, I was not using the fast load option. That is why it is inserting row by row.

Thanks guys..

SPN was not setup properly. It's fixed and working fine. Thanks.

No. SA account is not renamed.

Oops. correction.

I think if this issue will fix then I am sure I will not have SQL Agent issue. I did upgrade to 2008 on other server successfully but some...