Update Rollup 13 for Microsoft Dynamics CRM 4.0

Update Rollup 13 for Microsoft Dynamics CRM 4.0 http://blogs.msdn.com/b/crm/archive/2010/09/23/update-rollup-13-for-microsoft-dynamics-crm-4-0.aspx

What’s new in Microsoft Dynamics CRM 2011?

1.) New application features Visualization. On demand graphical charts for many record types. Improved user interface that includes the Office Ribbon design and more streamlined forms. Connections. A new feature for establishing relationships between records. Recurring activities. Schedule activities, such as appointments, that repeat. Queue enhancements. Auditing. To enable record level auditing, go to System [...]

Troubleshooting Microsoft CRM Asynchronous process jobs

1.       If any of the job’s status has changed from “Publishing” to “Unpublished”, most likely there are exceptions that caused the job to fail. a.       Run the SQL script to understand the cause USE Microsoft_MSCRM GO SELECT Name, ErrorCode, Message, * FROM AsyncOperation WHERE OperationType = 7 ORDER BY CompletedOn DESC Message column should contain [...]

Delete log and rebuild index of AsyncOperationBase and WorkflowLogBase table in Dynamics CRM using SQL Job

USE [msdb] GO /****** Object:  Job [Async-CleanUP]    Script Date: 05/27/2010 12:36:09 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 05/27/2010 12:36:09 ******/ IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’[Uncategorized (Local)]‘ AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’[Uncategorized (Local)]‘ IF (@@ERROR <> [...]

Update database statistics everyday

USE [msdb] GO /****** Object:  Job [Data_Update_statistics_everyday]    Script Date: 05/27/2010 12:32:03 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object:  JobCategory [Database Maintenance]    Script Date: 05/27/2010 12:32:03 ******/ IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’Database Maintenance’ AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’Database Maintenance’ IF (@@ERROR <> [...]

Rebuild Index of a database table

DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 90 CREATE Table #databaseName (dbid int identity(1,1), DbName Varchar(255)) Insert into #databaseName SELECT name FROM   MASTER.dbo.sysdatabases –  WHERE  name NOT IN ( ‘master’, ‘model’, ‘msdb’, ‘tempdb’, ‘distrbution’ ) WHERE  name IN ( ‘OD’) ORDER  BY 1 CREATE Table #TableName (Tableid [...]

Populate lookup value on selection of another lookup

I had client requirement that on the selection of City (lookup), Region and Sub Region should be populated automatically which is read only field. To achieve this we mapped the city with region (lookup) and sub region (lookup) on the city entity. After writing below code I was getting following error. There was an error [...]

Filtering multiple custom CRM Lookup

Let me explain the scenario.. We have a Model lookup and a variant Lookup on Lead form. Every variant is associated with a particular model. i.e One model have multiple Variant. Eg. Model          Varient Alto             Alto LX Alto             Alto Xcite Alto             Alto LXI SX4               SX4 VXI SX4               SX4 ZXI Leather SX4               SX4 ZXI —————————- Now [...]

Using the Advanced Find for FetchXML builder

You can just open the Advanced find page and build the query as you like. Then run the query to see if it returns the data as you wish it should. If you are satisfied with the results and you want to know what query was sent into the CRM Framework, then press F11 to [...]

CrmService.Create Method Using JScript

Create record using JScript This sample shows how to use the CrmService.Create method using the same example provided in the Server Programming Guide: CrmService.Create method. To test this sample: Paste the following code into any Event Detail Properties dialog box. Save the form and then click Create Form on the Preview menu. When the event [...]