I am looking for a DMV query which contain Dimension_Name and Object_ID together.

I have System.mdschema_dimensions to get the Dimension Unique name and System.discover_object_activity to get the Object_ID.

They showed together in the dimension properties and I'm interested if there's any DMV which shows them together.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.