Message Formating Problem

cranem451

/* 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'

Manfred.Castro

Please try this patch.
ftp://support.red-gate.com/patches/SQL_ ... 2.0.28.zip

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'