Well, I do *not* have any ALTER_ANY_EVENT_* permissions granted. The server version is:

Microsoft SQL Server 2014 - 12.0.4213.0 (X64)

Jun 9 2015 12:06:16

Copyright (c) Microsoft Corporation

Enterprise Edition:...

Great article and many thanks for describing this feature.

I followed the example, creating a new Session with the parameters you defined and so forth, but I cannot view it live....

I wholeheartedly agree with you, Steve, on getting along better with our peers at work. Friction between DBAs and the rest of the world is so commonplace, I almost...

I'm going to chime in on the 'Yay for sp_helptext' team.

The stored procedure might be old (and indeed in need for some TLC, thumbs up for the article!), it still...

I'm with @hr_sn on this. There is no reason to use sp_helptext and work at getting the output correct, when you can just right-click the procedure in...

SSC, in my humble opinion, should do it. As others have said, hearing about the process will be a tremendous learning experience for all. Plus, you'll be moving...

@victordba, the use of EXCEPT is a valid tool for investigative purposes. Running a MERGE is essentially an upsert, which you don't want if you are just...

Thanks, Steve. All references are welcome with open arms.

Thanks for the reply Lynn. I tried that and id did not work.

However, I did just now try a FULL OUTER join and moved the condition in the where...

I wish to throw in my 2-cents' worth to the conversation. I am one week away from reaching 51 years of age, and I am still doing very well...

--untested, xpath isn't my strong suite

select

T.C.value('./@keya', 'int') as KeyA,

T.C.value('./@keyb', 'char(1)') as Keyb,

T.C.value('./@keyc', 'int') as Keyc,

...

Thanks for the response. That gave me a return set, but what it did was stuff the entire subquery into an XML element. It looks like adding ",type"...

Thanks. That did work for me.