SQL Server Stored Procedure Cannot Be Modified According to “Wrong” Part of Comment

Question

I am writing this; I could not find an appropriate solution with this heading and decided to write a solution also here.

When we define a new stored procedure on SQL Server, it cannot be changed using the right-click method in accordance with some part of the “Syntax error” in the code

Syntax error in TextHeader stored procedure 'your_procedure'. (Microsoft.SqlServer.Smo)

So, you need to get the procedure code using the sp_helptext method.

In short, in another part of the comment /* */ should be a part of the separation of the comment /* */ . (This was my situation)

Please write here if you know other possibilities about

Syntax error in TextHeader stored procedure ...

error?

Answer 1

The other part of the comment /* */ should contain part (s) of the comment sections /* */ . Changing the / * * / split line in the main body of the comment.