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

Message Formating Problem

/* Start of Query */

USE AdventureWorks2008R2;

SELECT [dbo].[DatabaseLog].[DatabaseLogID]
, [dbo].[DatabaseLog].[PostTime]
, [dbo].[DatabaseLog].[DatabaseUser]
, [dbo].[DatabaseLog].[Event]
, [dbo].[DatabaseLog].[Schema]
, [dbo].[DatabaseLog].[Object]
FROM [dbo].[DatabaseLog]
WHERE [dbo].[DatabaseLog].[Object] LIKE 'PK_Product_ProductID'

PRINT 'LIKE ''PK_Product_ProductID'''

/* End of Query */


Output is displayed correctly when selecting the "Grid" Tab in the Results section. (PK_Product_ProductID)

Output is from the "Messages" Tab in the Results section. (PK-Product-ProductID)

Note that the 'Under Score' "_" character is being displayed as the Dash "-" character.

This is from a simple 'PRINT' command.

Output from the "Messages" Tab in the Results section.

<WIN7X64-2008RG\MSSQLSERVER1.AdventureWorks2008R2> Changed database context to 'AdventureWorks2008R2'.

<WIN7X64-2008RG\MSSQLSERVER1.AdventureWorks2008R2> (2 row(s) affected)

<WIN7X64-2008RG\MSSQLSERVER1.AdventureWorks2008R2> LIKE 'PK-Product-ProductID'
cranem451
0

Comments

2 comments

Sort by
  • Manfred.Castro
    Please try this patch.
    ftp://support.red-gate.com/patches/SQL_ ... 2.0.28.zip
    Manfred.Castro
    0
  • cranem451
    Thanks...

    It seems to be working correctly with the new version.
    Multi Script Ver: 1.1.0.34
    <WIN7X64-2008RG\MSSQLSERVER1.AdventureWorks2008R2> LIKE 'PK-Product-ProductID'

    Multi Script Ver: 1.2.0.28
    <WIN7X64_2008RG\MSSQLSERVER1.AdventureWorks2008R2> LIKE 'PK_Product_ProductID'


    Output from Multi Script Ver: 1.2.0.28
    <WIN7X64_2008RG\MSSQLSERVER1.AdventureWorks2008R2> Changed database context to 'AdventureWorks2008R2'.

    <WIN7X64_2008RG\MSSQLSERVER1.AdventureWorks2008R2> (2 row(s) affected)

    <WIN7X64_2008RG\MSSQLSERVER1.AdventureWorks2008R2> LIKE 'PK_Product_ProductID'
    cranem451
    0

Add comment

Please sign in to leave a comment.