Message Formating Problem

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Message Formating Problem

Postby cranem451 » Tue Jun 25, 2013 7:59 pm

/* 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
cranem@addendum.com
cranem451
 
Posts: 2
Joined: Tue Jun 25, 2013 7:07 pm
Location: Irvine, CA

Postby Manfred.Castro » Wed Jun 26, 2013 8:45 pm

Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

New version of SQL Multi Script 1

Postby cranem451 » Thu Jun 27, 2013 6:55 am

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
cranem@addendum.com
cranem451
 
Posts: 2
Joined: Tue Jun 25, 2013 7:07 pm
Location: Irvine, CA


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests