Isle.Of.Mull (9/19/2008)
Unfortunately, my web hosting vendor does not allow xp_cmdshell or sp_OACreate. 🙁I was looking at these options to move a file as well as means to export table data to a text file.
Could someone point me in the direction of another idea?
Thanks.
That's a real shame considering the frightful lack of security that a lot of web hosting vendors display that make any concerns about xp_CmdShell pale in comparison.
Use a batch file to run a stored procedure from SQLCmd and redirect the output to a file. Or, use Powershell.
--Jeff Moden
Change is inevitable... Change for the better is not.