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

When I create a stored procedure with comments the comments are stripped out.

SQL Server 2022

This occurs using

SQL Server 2022

SSMS:             20.2.30.0

SQL Prompt:       10.14.21.9884


Is this an issue with SQL Prompt: 10.14.21.9884 ?


This does not seem to be a problem with 

SQL Server 2022

SSMS:             20.2.30.0

SQL Prompt:       10.14.15.8425

markel522
0

Comments

2 comments

Sort by
  • DanC
    Hi @markel522

    Can you please elaborate on what you mean by the comments are stripped out
    DanC
    0
  • rickrode

    Many DBMSs remove comments from stored procedure definitions during compilation or storage to optimize storage and execution. Comments are considered metadata for developers and are not necessary for the execution of the procedure.

    @Ragdoll Hit

    rickrode
    0

Add comment

Please sign in to leave a comment.