Hi ! everbody ,
We 1st had 6.5 and after that i had upgraded to 7.0 now we are having the problem of executing xp_cmdshell for non-sa user . It used to work fine in 6.5 but in 7.0 it is not working we have done all kind of settings( we had done all kind of setting which we had in 6.5) but nothing yeild any +ve result like setting in the property of sql agent & using domain level account for both sql server & sql agent . if you could shed some light on this problem then it's great
Thank you in advance