Results pane in SSMS shows output and Return Value from which query?

Guus2005

AWF VIP
Local time
Today, 11:50
Joined
Jun 26, 2007
Messages
2,642
Code:
USE [databasename]
GO

set nocount on

DECLARE    @return_value int

EXEC    @return_value = [alg].[spGenerateFile4Process]
        @Outputfile = N'c:\temp\somefile.csv'

GO
A stored procedure is called and below is the result:
1715861188015.png

Is there a way to change the name of the column "output" to something more descriptive like "writing records to output"?

The above stored procedure exports a view to an outputfile.
I can't pinpoint where the first "output" is comming from.

This is a very simple stored procedure.
I have more complex stored procedures which shows a lot more results.
When debugging it would be helpfull to see which query/statement is causing the problems.

And yes, i know i can put every statement in a try-catch block and try to figure out where the problem-if any is occuring.
But i want to be able to look at the results and be able to see from which statement/query a certain "output" is comming from.

Thanks!
 
Have you examined the stored procedure code itself to see if it contains the word 'output' that may be naming that output column?
 

Users who are viewing this thread

Back
Top Bottom