Message Formating Problem

cranem451cranem451 Hemet, CAPosts: 3 Bronze 1
edited June 27, 2013 1:55AM in SQL Multi Script
/* 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'
Thanks,
Marc Crane
[email protected]

Comments

  • Manfred Castro
    Product Support
    Red Gate Software
  • cranem451cranem451 Hemet, CAPosts: 3 Bronze 1
    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'
    Thanks,
    Marc Crane
    [email protected]
Sign In or Register to comment.