SQL Server Performance Forum – Threads Archive
odd bcp problemHi, for the life of me I have not been able to post my question here as it contains sql code (an sql forum that inadvertantly disallows sql code <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />. <br /><br />Instead please seem my question here..<br /><br />Thanks<br /><br /<a target="_blank" href=http://www.rafb.net/paste/results/GfCCW247.html>http://www.rafb.net/paste/results/GfCCW247.html</a>
It’s the dreaded cmdshell bug – you cannot type xp_cmdshell in plain text – perhaps other xp_ commands as well. I added bold markers around xp_ and cmdshell, which is a silly workaround – but at least it works.
Thanks Adrian. Sadly Im not sure whether you had replied to the nopaste site, but it seems pastes get deleted after 24 hours <img src=’/community/emoticons/emotion-6.gif’ alt=’‘ /><br />I managed to restructure my query so it didnt require a temp table, and xpcmdshell worked fine.<br /><br />Do you have a link which tells me more about this bug please? I dont know what your proposed workaround was<br />Thanks<br />
Ahh, I feel a bit dumb now!<br /><br />I see you were replying to explain why I couldnt paste my SQL code to the forum, and not responding to my problem ont he nopaste site <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />
That link is not available…