• before running this query you need to configure with the following query

    sp_configure 'show advanced options', 1

    reconfigure

    go

    sp_configure 'Ad Hoc Distributed Queries', 1

    reconfigure

    Can you provide an explanation for running the procedures you mention.

    I find it beneficial to understand why there is a need to do so.

    Thanks!

    EDITED for clarity

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers