Query Analyzer : losing the ___ rows processed message

[Steve]

Hi;

I have been writing a lot of quick and diryt tsql scripts to correct
database issues.

I've been saving the output of the scripts for future records.

I have been executing them through query analyzer.

I find the messages query analyzer puts out to be obscuring to my
output: ie

" 6 rows processed "

Is there anyway to shut this off?

Steve

[David Portas]

Re: Query Analyzer : losing the ___ rows processed message

SET NOCOUNT ON

--
David Portas
------------
Please reply only to the newsgroup
--

[John Bell]

Re: Query Analyzer : losing the ___ rows processed message

Hi

You can also set this off by checking the option:

Tool/Options/Connection Porperties/Set NoCount

John

"Steve" <stevesusenet@y ahoo.com> wrote in message
news:6f8cb8c9.0 310040339.2041d 816@posting.goo gle.com...[color=blue]
> Hi;
>
> I have been writing a lot of quick and diryt tsql scripts to correct
> database issues.
>
> I've been saving the output of the scripts for future records.
>
> I have been executing them through query analyzer.
>
> I find the messages query analyzer puts out to be obscuring to my
> output: ie
>
> " 6 rows processed "
>
> Is there anyway to shut this off?
>
> Steve[/color]

[Steve]

Re: Query Analyzer : losing the ___ rows processed message

"David Portas" <REMOVE_BEFORE_ REPLYING_dporta s@acm.org> wrote in message news:<ELmdnZZku P2qV-OiRVn-hg@giganews.com >...[color=blue]
> SET NOCOUNT ON[/color]

Awesomely cool, many thanks

Steve