Post reply

[SQLSTATE 01000] within SP output

  • July 8, 2004 at 6:48 am

    #513835

    louis try this:

    EXEC xp_cmdshell 'osql /E /Q "<SQL>" -o "output.txt"'

    you pelican

  • July 10, 2004 at 10:05 pm

    #514208

    That worked to a point, but it start wrapping my text. Is there any other way to surpress the SQLSTATE 01000 error message?

  • July 10, 2004 at 10:09 pm

    #514209

    It seems to happen at the end of the print statement. I tried replacing it with select both adds more white space to the output. Is there another way to print text within an SP?

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply