thanks for the help. You answered my question why it was not working. xp_cmdshell only does one line at a time I did not know that. I went and wrote...