ISQL

  • I'm newbie to SQLServer world, I am using isql to create a text file from a query(using xp_cmdshell). I keep getting '(1 row affected)' message in my text file. Is there any argument or parameter that I can set to supress the info messages in ISQL, I know in Oralce SQL*PLUS you can set feedback off, I am looking for a similar functionality in ISQL.

    Thanks in advance

  • Try: SET NOCOUNT ON

    It is supposed to eliminate the statement returning the count. It's needed in some applications, especially when developers are using the data connection functionality for ASP web sites with Visual Interdev 6.0.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Thanks

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

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