Can someone help me to find out the query for below scenario:
We need to have a query based on DBC.DatabasesV to get lists of databases (Hierarchies) under a specific database (Master Database).
ie., Master database --> List of all child database under master database --> List of all databases under each and every child database etc...
Looking forward for your response.
Thanks in Advance.
dbc.ChildrenV will certainly be the most straightforward way, but if you are also looking for a lillte challenge, then try this :) This will give you indented list showing you DB hierarchy.