Greetings,

I have a sql STOREDPROCEDURE that ends with this statement

                begin catch
            Declare @exceptionText as nvarchar(max)
            exec @exceptionText =  usp_GetErrorInfo
            insert into Exceptions values
            (
                newid(),
                @exceptionText,
                GETDATE()
            )
            if (XACT_STATE()) = -1 rollback tran
        end catch

LLBL designer conceder this procedure as a retrieval sp not action sp, Is it correct ?! if yes..why ?

LLBL designer 2.6

You did not post the complete code of te SP, and so we can't tell if it returns any resultSet or not.

Anyway, whatever it returns, you can modify the resultSet count detected by the Designer, in the Catalog Explorer.