I just happened to notice that a comment I left on this question has disappeared.
It was in no way unconstructive or offensive so I think it is unlikely to have been flagged. I forget the exact text but it was something along the lines of.
Shame you are not on 2012 as this is much easier with
sys.dm_exec_describe_first_result_set
. Actually I don't think any of the solutions in the possible duplicate will work for you as you are unlikely to have permissions to set up a loop back linked server if adhoc distributed queries are enabled then you can achieve similar using [link to some other answer]
Was this auto deleted when the question was closed as duplicate? If so why? Does it delete all comments that link to other answers? Or all with the phrase "possible duplicate"?
If so that doesn't seem correct behaviour to me. I would expect only comments that link to one of the proposed dupes to be so deleted.