June 12, 2002 at 1:32 pm
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
June 12, 2002 at 1:55 pm
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
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
June 12, 2002 at 2:46 pm
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply