The OPENROWSET code and the examples are interesting, but I wonder about performance.

BTW, I'm always reluctant to change system parameters (in this case ad hoc dist queries) to achieve a goal. I would rather search for alternatives first (I'm far from an expert though ;))

The examples are ok for 2000. 2005 and up: better to use DMV's I suppose