CRM 2013: How to remove Business Process Flow

This is a good work-around to remove business process flows if you do not want them

Microsoft Dynamics 365 CRM Online Blog

Microsoft Dynamics CRM 2013 comes out of the box with three system created Business Process Flows, one for Case, Lead and Opportunity. They are activated and ready for use.

image

All existing CRM Cases, Leads, and Opportunities are defaulted to these new CRM 2013 Business Process Flows. Here is an example for a Lead:

image

I very much like Business Process Flow – however there are some CRM projects that just don’t need them yet and would be better off – have them disabled. So what is the best option to turn them off?

Here is a good approach:

Make a copy of the existing Business Process Flows. CRM Client > Settings > Processes > open the Business Process Flow (i.e. “Lead to Opportunity Sales Process”) > click on the “Save As” button to make a copy of it for re-use in the future.

image

Now you can “Deactivate” the Business Process…

View original post 46 more words

Advertisements

{ADVANCED CRM KNOW-HOW} Know Table sizes within your CRM DATABASE

Recently in my project, as part of maintenance and data clean up activity, we needed to know the relative sizes occupied by various tables in CRM database. This was to prioritize clean-up based on table sizes.

Since this was CRM on premise we could quickly fire a query to check this:

SET NOCOUNT ON

 

DBCC UPDATEUSAGE(0)

 

— DB size.

EXEC sp_spaceused

 

— Table row counts and sizes.

CREATE TABLE #t

(

    [name] NVARCHAR(128),

    [rows] CHAR(11),

    reserved VARCHAR(18),

    data VARCHAR(18),

    index_size VARCHAR(18),

    unused VARCHAR(18)

)

 

INSERT #t EXEC sp_msForEachTable ‘EXEC sp_spaceused ”?”’

 

SELECT *

FROM   #t

 

— # of rows.

SELECT SUM(CAST([rows] AS int)) AS [rows]

FROM   #t

 

DROP TABLE #t

This query uses a stored procedure provided by Microsoft to check space and runs it through all the tables in database.

The output is similar to below which can be saved to csv and then filtered to see which tables are using the most space:

clip_image001

It gives a quick indication on the number of rows, reserved space and unused one.

Hope it helps!