• As most of you stated, using DMV will be safe on the production server but working what ever the reason on a production server is having a damocles sword up your head.

    How many times a "Whoops" query was run unintentionally on a production server?

    Who will be blamed first if something wrong occurs while you are working on it even if it's not your fault?

    Using the less stressful, the minimum time and a tested & approved method to fetch only the require data on a production server is a safe bet to avoid anything that could go wrong. To my eyes, it is a safe way to do what you need to do.

    It's not because you could it means you should...

    It is a wonderful think to know to script out that and mimic a server! Thks Phil!