Suppress messages when executing a procedure

Question

Suppress messages when executing a procedure

StefanJ

SSCarpal Tunnel

Points: 4713
More actions
February 24, 2004 at 5:21 am

#107429

I had an example of the syntax I add to the end of an EXEC procName to suppress the message in QA Grids but I can no longer find it.

Viewing 9 posts - 1 through 8 (of 8 total)

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

set nocount off/on ?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

StefanJ SSCarpal Tunnel Points: 4713 More actions · Answer 2

Thanks Frank but I was looking for the command which I could add to the end of the EXEC statement which would suppress the messages in the Query Analyzer grid.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Stefan,

which messages do you mean? Can you post an example?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

StefanJ SSCarpal Tunnel Points: 4713 More actions · Answer 4

In Query Analyzer I am running the following code:

DECLARE @ReturnStatus int
Exec @ReturnStatus = procZipFilePassword 'C:\KnowledgeBase\Templates\CompanyPotentials.xls', 'C:\KnowledgeBase\WebTestFiles\CompaniesPotentialsNL','test'

In the Grids window below I get the following output.

WinZip(R) Command Line Support Add-On Version 1.0 (Build 3181)
Copyright (c) WinZip Computing, Inc. 1991-2000 - All Rights Reserved
Searching...
Warning: name not matched: C:/KnowledgeBase/Templates/CompanyPotentials.xls
Error: No files were found for this action that match your criteria - nothing to do. (C:\KnowledgeBase\WebTestFiles\CompaniesPotentialsNL.zip)
NULL

In the past I used a command on the end of the EXEC statement to suppress the output in the grids window. I just can't remember or find what it was.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

The only thing I can think of is NO_OUTPUT if you use xp_cmdshell in your s_proc.

HTH

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

wz700 SSCertifiable Points: 7133 More actions · Answer 6

wz700

SSCertifiable

Points: 7133

February 24, 2004 at 3:55 pm

#495438

Are you talking

set noexec on

or

set parseonly on

StefanJ SSCarpal Tunnel Points: 4713 More actions · Answer 7

No, it went on the end of the EXEC statement following a comma. Perhaps I imagined it. It will come to me one day.

StefanJ SSCarpal Tunnel Points: 4713 More actions · Answer 8

Frank, I missed your reply above. It was NO_OUTPUT that I was looking for.

Thanks