Thanks a lot.

The script was very helpful.

it is not working for any of the maintenance plans that we set up...

i have created the sql agent jobs instead of maintenance plans and they are running fine.

I think...

i have checked the domain and the maintenance plans.

Domain is same and the maintenanace plans exists.

other SQL server jobs are working fine but the backup subplans created during the creation...

You can change the permissions whenever you want.

just remove the db_owner database role and add the other two roles. It gives the error still it creates the user.

and you can...

thanks alot guys...

i got it.

ssms -> instance - > databases-> master -> programability -> extended stored procedures -> xp_cmdshell -> righ click - properties ......

Steve ,.. will you please tell me the process to change it in Master. I may not change it but would like to know the way we do it.

thanks

how to give access of xp_cmdshell at user level.

i mean, if i need to give permission to only one user who is not sysadmin to access xp_cmdshell, how do we...

I was unaware of this xp_cmdshell proxy account .. thanks alot for the reply

thanks for the reply...

the requirement is ,... instead of giving a sysadmin role. I need to chose few permissions to satisfy all the permissions.

using

db_creator

bulk admin and

xp_cndshell proxy account...

Hi kishore,

thanks alot the link you posted helped me alot.

Hi,

I have gone through the discussion and was great to know many things in it.

I am new to this parallelism and cxpacket and would like to know...