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 …',
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;