I have a stored proc that writes the output of a Select Statement to a table with an xml data type (see attached file). Everything worked fine on the Development box but when I pushed to Production, the DBA has xp_cmdshell locked down and he will not unlock it just for this process.
Is there any other way to automate the creation a physical XML file? I need a file to ftp to a customer. StoredProc1.txt