Category: SQL Server

Recover CRM Encryption Symmetric Key

Sometimes, after restoring a CRM On-Premises organization (from a database backup), you end up with the Data Encryption inactive (Settings > Data Management > Data Encryption) and that might be a headache for future development on the restored organization (e.g. custom plugins), especially if the original organization Encryption Key cannot be shown as below (Show… Continue reading Recover CRM Encryption Symmetric Key

Attribute Type differences

Because we all know that maintaining two on-premise environments (e.g. dev & production) can be a pain, sometimes checking certain entities before solution import can be a time saver! To check the data type differences between the attributes of the same entity, on two different organizations, you can use the following SQL statement: — USAGE:… Continue reading Attribute Type differences

Solution Component Types

Any importable CRM solution holds within the *.zip file a component named solution.xml. In order to edit this, you need a better understanding of the <RootComponent> nodes (type attribute). For a complete list of root component types, you can use the following SQL statement: SELECT AttributeValue as Type, Value as [Root Component] FROM StringMap WHERE… Continue reading Solution Component Types

Activity typed Entity – Display in Activity Menus

Upon creating a custom entity as Activity Entity and not checking the “Display in Activity Menus” option, there is no supported way to alter this. However, here is the unsupported approach (in SQL): UPDATE Entity SET ActivityTypeMask = 1 WHERE EntityId = (SELECT EntityId FROM Entity WHERE Name = ‘custom_entity_schema_name’) After this minor adjustment, a… Continue reading Activity typed Entity – Display in Activity Menus

View all registered Plugin Steps (SQL)

To view all the registered Plugin Steps (for all the plugins) in a single query, use the following SQL statement: SELECT T.PluginAssemblyIdName AS PluginName, S.name AS StepName, S.description AS StepDescription, M.name AS Action, E.name AS Entity, CASE S.Stage WHEN 20 THEN ‘PRE’ WHEN 40 THEN ‘POST’ ELSE ‘OTHER’ END AS Stage, CASE S.StateCode WHEN 0… Continue reading View all registered Plugin Steps (SQL)