I can't agree with the given answer. I ran the query without having permission to xp_cmdshell and got the error stated. However, running the same query logged in as SA...