How to get Organization & Sql Server Database name in MS CRM using SQL Server
i had a problem to figure out what database is used and which one is production.
finally i got the solution to my problem for configuring the Dynamics CRM installation
SELECT DatabaseName [DATABASE NAME], FriendlyName [ORGANIZATION NAME], SqlServerName [SQL SERVER NAME], SrsUrl [SSRS URL], [ORGANIZATION STATUS] = CASE WHEN STATE=1 THEN 'ENABLED' WHEN STATE=0 THEN 'DISABLED' END FROM
[MSCRM_CONFIG].[DBO].[ORGANIZATION]
No comments:
Post a Comment