??????? 4.0 ?? Microsoft Dynamics CRM ???? ??????? ?????? ??? ?????? ????? ?????? ?????????? ???????? ????? ?????? ?????????? ????? ?? Microsoft Dynamics CRM

???? ???????: 959248 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

???????

??? ?????? ????? ?????? ?????????? ???????? ????? ?????? ?????????? ????? ?? Microsoft Dynamics CRM ???? Microsoft Dynamics CRM 4.0 ??????? ??????. ????? ?? ???? ??? ???? ??? ????? ????. ???? ??? ??????? ??? ????? ???????? ?????????:
  • ?????? ?????? ?? ????? ?????? ??????????.
  • ????? ???? Microsoft SQL Server ??? ?????? ?? ???????. ??? ???? ??????? ????? ?????? ??? ???? ?? ????? ActivityParty ??????? ???????? ActivityPointer.
???? ??? ?????? | ????? ???????

????

?? ????? ??? ??????? ?? ???? ?????? ??????? ??????? ?? Microsoft Dynamics CRM 4.0. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
949256
(http://support.microsoft.com/kb/949256/ )
??????? 4.0 ?? Microsoft Dynamics CRM ????????? ?????????? ???????

??????? ???????

????? ????????? ??? ??????? ??? ????? ????????? ???? ?????? ?????? Microsoft Dynamics CRM 4.0 ???????.

?????? ???? ????????? ??? ??????? ??? ???? ????? ????? SQL Server ?????? ??? <OrganizationName> _MSCRM ????? ????????. <OrganizationName> ?????? ?????? ??? ??????? Microsoft Dynamics CRM. ????? ?????? ???? ??? ?? ??? ????? ??? ??????? ??????.

??? ????? ??????? SQL Server ?????? ???? ?? ??? ???? ????? SQL Server ?????? ?????? ?? ????? ?????? MSCRM. ?????? ????? ?? ?????? ??????? ??????? ????? ????? ?????? MSCRM:
sp_helpindex ActivityPointerBase
sp_helpindex ActivityPartyBase
sp_helpindex EmailBase
?? ???? ???? ????? SQL Server ?????? ????? ??? ??????? ?? ????? ??????? ??? ???:
index_name index_description index_keys
cndx_ActivityPointer ?????? ? ?????? ??????? ??? ActivityId PRIMARY, StateCode, ActivityTypeCode
??????? ??? ScheduledEnd PRIMARY RegardingObjectTypeCode nonclustered ndx_ActivityPointerCover1
???? ?? ???? ?? ?? ????? SQL Server ?????? ??????? ???? ?? ????? ??? ?? ????? ?????. ??? ?? ????? ???? ???? "? ????? ???? Microsoft Dynamics CRM SQL ???? ????? ?? ????.

?????? ????? SQL Server ?????? ????? ????? SQL ??????? ?? Studio ????? ???? SQL. ????? USE <OrganizationName>_MSCRM statement to the actual organization and database name.

USE <OrganizationName>_MSCRM
GO

CREATE NONCLUSTERED INDEX [CRM_ActivityPartyBase_EmailRouter1] ON [dbo].[ActivityPartyBase] 
(
[ActivityId] ASC,
[ParticipationTypeMask] ASC,
[PartyId] ASC
)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [CRM_ActivityPartyBase_EmailRouter2] ON [dbo].[ActivityPartyBase] 
(
[ParticipationTypeMask] ASC,
[PartyId] ASC
)
INCLUDE ( [ActivityId],
[ActivityPartyId]) 
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [CRM_ActivityPartyBase_EmailRouter1] ON [dbo].[ActivityPointerBase] 
(
[ActivityTypeCode] ASC,
[statecode] ASC,
[actualend] asc,
[statuscode] asc
)INCLUDE ([activityid], [modifiedon], [deletionstatecode])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [CRM_ActivityPointerBase_EmailRouter2] ON [dbo].[ActivityPointerBase] 
(
[statecode] ASC,
[ActivityTypeCode] ASC,
[deletionstatecode] asc
)INCLUDE ([ActualEnd], [StatusCode], [ActivityID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [CRM_EmailBase_EmailRouter1] ON [dbo].[EmailBase] 
(
[activityid] asc,
[deliveryattempts] asc,
[DirectionCode] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 
ON [PRIMARY]
GO

????????? ????????

??? ?? ???? ???? Microsoft Dynamics CRM 4.0 ????? ????? ?????? ????????? ??? ???????.

????? ????? ?????

??? ??? ??????? ?????? ????? ???? ?????????? ??? ????? ????? ????????? ??? ????? ?????? ????????? ??? ???????.
???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

??????? ????

????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684
(http://support.microsoft.com/kb/824684/ )
??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
?????? ??? ???? ?? ????????? ??? Microsoft Dynamics CRM ??????? ??????? ?????? ???????? ???? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
887283
(http://support.microsoft.com/kb/887283/ )
???? ??????? ?????? ????? Microsoft CRM ???? ????? ?????? ?????? ???????
???? ??? ?????? | ????? ???????

???????

???? ???????: 959248 - ????? ??? ??????: 28/???/1430 - ??????: 4.0
????? ???
  • Microsoft Dynamics CRM 4.0
????? ??????: 
kbmt kbmbsemail kbfix kbautohotfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe kbhotfixserver KB959248 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????959248
(http://support.microsoft.com/kb/959248/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????