?? ?? Microsoft Dynamics CRM ?-??? ???? ?? ????? ?? ?-??? ????? ??????? ???? ?? ??? unacceptable ???? ???? Microsoft Dynamics CRM 4.0

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

?????

?? ?? Microsoft Dynamics CRM ?-??? ???? ?? ????? ?? ?-??? ????? ???????, Microsoft Dynamics CRM 4.0 ???? unacceptable ???? ?? ???? ?????, ??? ?????? ????? ???? ???? ?? ????? ?? ?????? ?? ???? ?? ??? ????? ????????? ???? ???? ???::
  • ?? ?? ?-??? ????? ??????? ?????
  • Microsoft SQL Server ?? ?????? ??? ?? ??????? ??? ?????? ?? ???, ????? ??? ?? ?? ???? ?? ???? ActivityParty ?????? ?? ActivityPointer ??????? ???

????????

?? ?????? Microsoft Dynamics CRM 4.0 ?? ??? ?????? ????? ?????? ????? ??? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
949256Microsoft Dynamics CRM 4.0 ???????? ?? ??????????

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

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

?? ????? ?????? ????? ?? ??????????? ?? ??? ???? ?? ??? ?? ???????? SQL Server ????????????? ??? ?????? ??????<organizationname></organizationname>??????? _MSCRM ???<organizationname></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 clustered, ????? ???????? ActivityId, StateCode, ActivityTypeCode ?? ????? ????
ndx_ActivityPointerCover1 nonclustered ???????? ScheduledEnd, RegardingObjectTypeCode ?? ????? ????
?????? ???? ?? ??? ?? ???????? SQL Server ????????????? ??? ????? ?? ???? ????????????? ??? ???? ???? ???? ??? ??? ????????? ??????????? ????? ??, ?? ??? Microsoft Dynamics CRM SQL ??????????? ???? ???? ????? ??? ?????

???????? SQL Server ??????????? ?????, ???? ?? ??? ????? SQL ??? SQL Server ??????? Studio ??? ?????? USE ????????? ????<organizationname></organizationname>_MSCRM ??? ?? ???????? ????? ?? ??????? ?? ??? ???

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 ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
824684Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????
Microsoft Dynamics CRM ?????????? ???????? ?? ?????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
887283??????? ?????? CRM Microsoft ?????????? ???????? ?? ?????? ?????? ?????? ????

???

???? ID: 959248 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft Dynamics CRM 4.0
??????: 
kbmbsemail kbfix kbautohotfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe kbhotfixserver kbmt KB959248 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:959248

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com