Thursday, February 16, 2012 11:41 AM
pablop
How to get the sql server database of an organization?
I want to share a quick tip that learned today.
Within Deployment Manager, when we double click an Organization we have this data available to see (or edit if organization is disabled):
What happens if we want to know exactly which SQL Server Database corresponds to each organization
So, the quick tip is querying Organization table from MSCRM_CONFIG database in order to find out this information.
By running this query within MSCRM_CONFIG database we should be able to easily identify each organization:
SELECT [DatabaseName]
(result)
Hope you find this helpful,
PP [twitter: @pabloperalta ]
Filed under: dynamics crm , dynamics crm 2011