Comments
1 comment
-
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:
- In SSMS, navigate to the stored procedure in Object Explorer.
- Right-click on the stored procedure and select Properties.
- Go to the Extended Properties tab to view the description.
Are you seeing the description listed in the Extended Properties of your SP?
Add comment
Please sign in to leave a comment.
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;