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

Script Object As Alter

Whenever I use Script Object As Alter on a stored procedure the resulting SQL has the following warning:

  The EOL marker sequence is not the expected CR/LF

on every line which I then have to fix.

Is there a setting in SQL Prompt or SSMS which will fix this?
keith_m
0

Comments

3 comments

Sort by
  • Victoria W
    Hi @keith_m

    Please can you provide the create script of the proc in question?
    Victoria W
    0
  • keith_m
    Hi @Victoria W

    It's all stored procedures. In fact anything we use Script Object As Alter on has the same issue, stored procedures and views for instance.

    Using SSMS "Script stored procedure to..." doesn't have the same issue.

    The files we use to create the objects in the first instance have CRLF end of line sequence.

    Keith
    keith_m
    0
  • Dan_J
    Hi @keith_m

    I've tried to replicate the issue you are seeing here, but have so far not been successful.

    Would it be possible for you to provide a screenshot of the error you are seeing along with some of the script?

    Also, please can you confirm what versions of SQL Prompt and SSMS you are currently using?

    Finally, would it also be possible for you to provide your Verbose log files (https://documentation.red-gate.com/sp10/troubleshooting/finding-the-sql-prompt-log-files)?


    Dan_J
    0

Add comment

Please sign in to leave a comment.