• There are two different ways to display query results in the SQL Server Management Studio (SSMS) - text or grid view. Per the previous post, they act differently.

    I guess the question is where are you determining it does not work??

    Remember, WINDOWS versus UNIX differs in end of line (EOL) markers. WINDOWS = CR+LF: CR (U+000D) followed by LF (U+000A), UNIX = LF only.

    Something many people forget when transferring files.

    We wait to hear back from you on what tool you are using to determine that the EOL characters are not there.

    John Miner
    Crafty DBA
    www.craftydba.com