I guess I have never been a fan of triple quoting, I usually use CHAR(39) I find it is a lot easier to read for others:

SELECT 'O' + CHAR(39) +...

Did you get his resolved? It just started happening to me also, I am running SQL2008 R2, Win7 Pro 64 bit. Profiler worked yesterday but today it is...