This worked...thanks. Didn't try the job one. But thanks for that as well..
happycat59 (6/17/2013)
Have you tried putting your code in a stored procedure and using the "EXECUTE AS" option in that stored procedure so that it executes as a user who is permitted to run xp_cmdshell ?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.