Category: SQL Server 2008

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)