Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing showing return value on interactive stored proc execution

Status
Not open for further replies.

BobRodes

Instructor
May 28, 2003
4,215
US
One of my coworkers is running a stored proc from the SQL Server Management Studio (2005), by right clicking on it and selecting Execute Stored Procedure. The resulting query comes up like this:
Code:
USE [MYDB]
GO

DECLARE	@return_value int

EXEC	@return_value = [dbo].[BobTest1]
		@StartDate = N'20110101',
		@EndDate = N'20110401'

SELECT	'Return Value' = @return_value

GO
She doesn't want to see the return value in the result, and doesn't want to comment out the [tt]SELECT 'Return Value' = @return_value[/tt] statement either. Is there some sort of setting somewhere that will tell the interactive execution process to suppress showing this value? (I kind of doubt it because it's best practice, but I said I'd research it.)

TIA

An unforeseen consequence of the information revolution has been the exponential propagation of human error.
 
As far as I know there is no way to do that.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top