Post reply

How to disable Result Set for BCP

  • February 3, 2009 at 4:28 am

    #130658

    Hi all,

    I noticed that whenever I run the bcp command,

    Example: EXEC master..xp_cmdshell 'echo test > c:\test.txt'

    It will always return an OUTPUT field with value NULL in the Results Pane, it is possible to disable it?

    I'm trying to append a text file using bcp command which will be excecuted many times, and I would like to avoid the following error.

    "The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid"

  • February 3, 2009 at 11:01 am

    #937369

    Are you looking for "no_output" ?

    that is a parameter of xp_cmdshell not bcp.

    xp_cmdshell { 'command_string' } [ , no_output ]


    * Noel

  • February 3, 2009 at 6:56 pm

    #937664

    Thanks a lot, that is what I needed. 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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