How can we help you today? How can we help you today?

Description of parameters

Hi,

 

I made a stored procedure with various parameters in SSMS 18.9.1. In order for my colleagues to use it easily i want to add descriptions instead of the default info:

 

 

How can i add descriptions? 

I tried with sp_addextendedproperty  without luck. The description is created but not visible when trying to execute the procedure.

 


EXEC sys.sp_addextendedproperty 

@name = N'MS_Description', @value = N'Denne parameter bruges til at …', 

@level0type = N'SCHEMA', @level0name = dbo, 

@level1type = N'PROCEDURE', @level1name = DinProcedure, 

@level2type = N'PARAMETER', @level2name = @DinParameter;

ABI
0

Comments

1 comment

  • Christian Perez
    Official comment

    Hi ABI,

    Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with Descriptions on your Stored Procedures. In this case, I am curious if the description was actually added but is just not visible when executing the stored procedure. Could I have you try the below please:

    1. In SSMS, navigate to the stored procedure in Object Explorer.
    2. Right-click on the stored procedure and select Properties.
    3. Go to the Extended Properties tab to view the description.

    Are you seeing the description listed in the Extended Properties of your SP?

    Christian Perez

Add comment

Please sign in to leave a comment.