The queries returned by Profiler in a trace, use quotation marks around the table and collumn names i.e.
SELECT DISTINCT "Global Sales"."CONSOLIDATION", "Global Sales"."CURRENCY" FROM "Global Sales"
To use this query in Query Analyzer, I must first edit the quotes to brackets  i.e.
SELECT DISTINCT [Global Sales].[CONSOLIDATION], [Global Sales].[CURRENCY] FROM [Global Sales]
This is a PITA ;)...
Is there an option someplace to have Query Analzyer recognize the quotes? Or for Profiler to report with brackets? Or another solution perhaps?
One Orange Chip
SET QUOTED_IDENTIFIER ON
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Great thanks, and I didn't have to wait for someone in the USA to wake up! 🙂
Viewing 3 posts - 1 through 2 (of 2 total)