Text in multiple lines: Is this a bug in SQL Server 7

[chintapalli]

Hi,

One of my SP's parameter's text spans into multiple lines. But the SP adds the text of the first line only and ignores rest of it.

The following SP inserts only the text 'Arithmetic' and NOT 'Arithmetic operation resulted in an overflow.' for the first field of the table in the database.

EXECUTE ErrorInsert 'Arithmetic
operation
resulted
in
an
overflow.', '

http://localhost/Admin/ErrorTest.aspx'

But when I change the entire text to fit into one line like this, it inserts the entire string:
EXECUTE ErrorInsert 'Arithmetic operation resulted in an overflow.', '

http://localhost/Admin/ErrorTest.aspx'

Anyone know why?

Thanks.

Harish.

 

[chintapalli]

Never mind, that was a carriage return problem.

Harish.