HOW TO GET THE SQL SERVER DATABASE OF AN ORGANIZATION?
Nuestro estimado MVP Pablo Peralta nos comparte el artículo:
HOW TO GET THE SQL SERVER DATABASE OF AN ORGANIZATION?
What happens if we want to know exactly which SQL Server Database corresponds to each organization? Normally their names matches but sometimes (as happened today to me) it doesn’t ;).
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]
,[FriendlyName]
,[SqlServerName]
,[SrsUrl]
Ver más aquí
Saludos
Fernando García Loera (Community Program Manager – Latin America Region)