Script Object As Alter

keith_m

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?

Victoria W

Hi @keith_m

Please can you provide the create script of the proc in question?

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

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)?