?? ????? ????? ?????????? ?? ????? ???????? ?? Microsoft CRM 3.0 ?? ?? ????? ???????? ?? Microsoft CRM 3.0 ??? Microsoft Excel

???? ???????: 911022 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
?? ????? ??????? ?????? ?????? ?? ??? ??????? ??????? ?????? ?? Microsoft Dynamics CRM ?? ??????? ???????? ?? Microsoft Dynamics CRM.
??? ????? ??? ??????? ??? ??????? ??? ????? ????? ???????. ???? ?? ??? ???? ???????? ?? ????? ??? ??????. ???? ?? ????? ????? ???????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ??????? ????????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
256986
(http://support.microsoft.com/kb/256986/ )
??? ??? Microsoft Windows
????? ???? | ?? ????

?? ??? ??????

???????

?? ????? ????? ?????????? ?? ??????? ?????? ?? ?? ??? ??? ?? ????????? ???????:
  • ????? ???????? ?? Microsoft Dynamics CRM 3.0
  • ????? ?????? ?? Microsoft CRM 3.0 ??? Microsoft Excel
?? ????? ?????? ??? ??? ?????????? ?? ????? ????????? ??????? ?? Microsoft CRM 3.0 ?? ?? ????? ??????? ????? ?? Microsoft CRM 3.0 ??? Excel. ?? ????? ????????? ??????? ??? ????? ??? ?????? ?????? ?????????? ?????? ??????.
???? ??? ?????? | ????? ???????

????

??? ??? ???????? ???? ??????? ???????:
  1. ?? ?????? ??????? ?????? ?????? ?? ??? ???????. ??? ????? ??????? ?????? ???? ?????????? ??? ??????? ???????? ?? Microsoft CRM 3.0 ?? ?? Microsoft Dynamics CRM 3.0 Professional ?????? ????. ???????? ??? ???? ?????????? ?? ???? ????? ???????? ?? Microsoft CRM 3.0 ??? Microsoft Excel ?? ?? Microsoft Dynamics CRM 3.0 Professional Edition ?????? ???? ??? Microsoft Excel. ????? ?? ?????????? ???? ??? "??????? ??????? ??????".
  2. ????? ??????? ??????. ??? ????? ??????? ?????? ?????????? ?? ???? ??????? ?? ???? ????? Excel ?? ??? ????? ???? Microsoft CRM ?? ?? Microsoft Dynamics CRM 3.0 Professional ???? ????? ???? "????? ?????" ?????? ???????? ??? Microsoft Excel. ????? ?? ?????????? ???? ??? "????? ????? ??????? ??????".
  3. ????? ????? ?????? ???? ???????? ????? ??????? AlternateDataSource ?? ?? ?????? ????? ???????? ?? ????? ???????? ??? ??? Microsoft Excel. ???? ??????? ????? ?????? ?? ?? ???????? ???? ??????? ?????? ?? Microsoft CRM 3.0 ?? Microsoft Dynamics CRM 3.0 Professional ?????? ???? ??????? ????? ?? ???? ?????? ???. ????? ?? ?????????? ???? "????? ????? ????? ?????? ????" ?????? "????? ????? ????? ???????? ?? ????? ?????? ???? ??? Excel".

    ?????? ??? ?????? ??? ??? ??????? ????? ???????? ????? ????? ?????? ?? Excel ??? ???? ??? ?????? ???????:
    • ??? ????? ???? ??? ????? AlternateDataSource ????? ?????.
    • ??? ??? ???????? ?? ?????? ??????? ??? ????? ?????? ????.
    ??????? ???? ??????? ???????? ?? ??????? ???????:
    ??? ???????: SQLState: ??? ???? SQL '08004': ??? ?????? ??????? 4060; ?? ??? ?????? ??? ????? ???????? ??????? '.

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

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

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

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

????? ??? ??????? ?????? ??? ????? ????????? ???? ???? ????? ??????? Microsoft CRM 3.0 ???? Microsoft CRM 3.0 Server ?? Microsoft Dynamics CRM 3.0 Professional Edition ?????? ????.

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

?? ???? ??? ??????? ?????? ?????? ??? ??????? ??????.

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

?? ????? ????? ??? ??????? ??????.

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

??? ??? ????? ?????? ????? ???? ????????? ??? ????? ??? ??????? ??????.

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".

???? Microsoft Dynamics CRM 3.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Appgrid.htc??? ???? ???????11,815?? ???? ????23: 44
Microsoft.crm.application.components.application.dll3.0.5300.1085596,760?? ???? ????23: 58
Microsoft.crm.application.pages.dll3.0.5300.1085736,024?? ???? ????23: 58
Print_dlg.aspx??? ???? ???????8,816?? ???? ????23: 44
???? Microsoft Dynamics CRM 3.0
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Appgrid.htc??? ???? ???????11,815?? ???? ????23: 44
Microsoft.crm.application.components.application.dll3.0.5300.1085686,856?? ???? ????11: 56
Microsoft.crm.application.pages.dll3.0.5300.1085965,384?? ???? ????11: 56
Print_dlg.aspx??? ???? ???????8,816?? ???? ????23: 44
Systemsettings.aspx??? ???? ???????33,171?? ???? ????23: 44
Microsoft Dynamics CRM 3.0 Professional Edition ????? ???? ????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Appgrid.htc??? ???? ???????11,815?? ???? ????23: 44
Microsoft.crm.application.components.application.dll3.0.5300.1085596,760?? ???? ????23: 58
Microsoft.crm.application.pages.dll3.0.5300.1085736,024?? ???? ????23: 58
Print_dlg.aspx??? ???? ???????8,816?? ???? ????23: 44
Microsoft Dynamics CRM 3.0 Professional Edition ????? ????? ??????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ???????????????
Appgrid.htc??? ???? ???????11,815?? ???? ????23: 44
Microsoft.crm.application.components.application.dll3.0.5300.1085686,856?? ???? ????11: 56
Microsoft.crm.application.pages.dll3.0.5300.1085965,384?? ???? ????11: 56
Print_dlg.aspx??? ???? ???????8,816?? ???? ????23: 44
Systemsettings.aspx??? ???? ???????33,171?? ???? ????23: 44

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

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

?????? ??? ????? ??? ??????? ?????? ?????? ?????????? ??? ???? ??? ????? ???????? ?? Microsoft CRM 3.0 ?? ?? Microsoft Dynamics CRM 3.0 Professional ?????? ????. ???????? ??? ???? ?? ????? ?????????? ?? ????? ???????? ?? Microsoft CRM 3.0 ?? Microsoft Dynamics CRM 3.0 Professional ?????? ???? ??? Excel. ???? PivotTable ?????????? ???? "???? ??? ??????????" ????? ???????? ?????????? ?? Excel.
  1. ????? Microsoft CRM 3.0.
  2. ??? ???? Microsoft CRM ???? ??? ???? ? ???? ??? ????? ????? regedit ?? ???? ??? ?????.
  3. ??? ???? ?? ???? ??? ????? ??????? ?????? ??????:
    HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
  4. ?? ??????? ????? ? ??? ??? ???? ?? ???? ??? ???? DWORD.
  5. ???? DoNotAllowStatic ?? ?? ???? ENTER.
  6. ???? ??? ?????? ?????? ??? DoNotAllowStatic ??? ?? ???? ??? ?????.
  7. ?? ?????? ?????? ?????? ? ???? 1 ?? ???? ??? ?????.
  8. ?? ??????? ???? ???? ??? "?????" ?????? "???? ???????.

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

?????? ??? ????? ????????? ???????? ?? ??? ??????? ???? ?? ?? ???? ???? ???????? ????? ?? ????? ???????? ???? ????? ??????? ???? ???? ?????.

?????? ????? ?????? ???? ??? ????? ????? ????????? ????? ?????? Microsoft CRM 3.0 ???? ????? ?? ?? ?? ???????? ????? ???????? ?? ?????? ??????????. ??? ???? ??????? ?? ????? ????????? ?????? ???????? Adventure_Works_Cycle_MSCRM ??? ?? ???????? ?? Adventure_Works_Cycle_MSCRM_Alternate.

?????? ????? ??????? ??????? ?? ???? ????? ????????? ?????? ???????? Microsoft CRM 3.0 ????? ??? ??? ????? ????? ????? ?????. ??? ???? ??????? ????? ????? ????? ????????? ????? ?????? ?????.

?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ?????? Microsoft SQL Server ?????????? ???? ???????? "???" ? "???????" ?? "??? SQL Server ???????". ????? ?? ????????? ??? "??? SQL Server ???????" ?? ?????? ???? Microsoft ?????? ??? ?????:
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
(http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx)
??? ?? ??? ???????? ????? ???????? Adventure_Works_Cycle_MSCRM ?????? ?????? ????, ????? ????? ???????? ???? ?? ??? ?? ????? ???????? ??? ????. ?????? ????? ?????? ?????? ?????? ?????? ???? ???????? ???????? ???????? ?? ?????? ??????.

?????????
  • ????? ??????? SQL ????? ????? ?????? MSCRM ??? ?????. ???? ????? ?????? CustomerAddressBase ?? ????? ?????? Adventure_Works_Cycle_MSCRM_Alternate ??? ?????? ???????? ??? ????? ???????? ?? ??? ADDRESS1_LINE1 ??? ????? "?????". ???????? ??? ?????? ?? ????? ?????? PivotTable ???????? ?? ???? "???? ??? ??????" ????? ???? ???????? ?????? ??? ?? ???? ????? Excel ?? ??? ????? ???? Microsoft CRM.
  • ??? ????? ????????? ???????? ?????? ??? ??? ???? ?? ??? ?????? ?? ???? ?? ????? ADDRESS1_LINE1 ? ????? ????? ??? ??????? ?? ????? ?????? ????.
???????? ??? ?????? ???? ??????? ???????:
  1. ???? ??? ???? ???? ??? ??????? ???? ??? Microsoft SQL Server ? ?? ???? ??? ???? ???????.
  2. ?? ???? ?????? ??????? ?? SQL Server ???? ??? ?????? ???? Microsoft SQL ?? ???? ????? ?????? ?? ???? ??? ?????.

    ?????? ??? ????? ?????? ??????? ????? ???? SQL.
  3. ?? ??????? ????? ???????? ??? ???? ??????? ???? ??????? SQL "? ???? ??? ????? ?????? ??????. ??? ???? ??????? ???? ??? ????? ???????? Adventure_Works_Cycle_MSCRM_Alternate.
  4. ???? ????? ?????? ?? ???? ??????? ??? ?? ???? ??? "?????" ?? ??????? ???????: 
    USE Adventure_Works_Cycle_MSCRM_Alternate
GO
UPDATE CustomerAddressBase
SET Line1 = '',
City = ''

????? ????? ????? ???????? ?? ????? ?????? ???? ??? Excel

??? ??? ?? ????? ?? ??????? ????? ?????? ???? ??? ????? ??????? ??????. ?????? ????? ???? ??? "????? ????? ??????? ??????".
  1. ????? Microsoft CRM 3.0.
  2. ??? ???? Microsoft CRM ???? ??? ???? ? ???? ??? ????? ????? regedit ?? ???? ??? ?????.
  3. ??? ???? ?? ???? ??? ????? ??????? ?????? ??????:
    HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
  4. ?? ??????? ????? ? ??? ??? ???? ?? ???? ??? ???? ?????.
  5. ???? AlternateDataSource ?? ?? ???? ENTER.
  6. ???? ??? ?????? ?????? ??? AlternateDataSource ??? ?? ???? ??? ?????.
  7. ?? ?????? ?????? ?????? ? ???? ???? ????? ???? ????? ??????? ?? ???? ??? ?????: 
    DRIVER=SQL Server;APP=Microsoft Office 2003;Network=DBMSSOCN;Trusted_Connection=Yes;SERVER=ServerName;DATABASE=DatabaseName
  8. ?? ??????? ???? ???? ??? "?????" ?????? "???? ???????.
???? ??? ?????? | ????? ???????

?????

Microsoft Dynamics CRM 3.0

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

Microsoft Dynamics CRM 3.0 Edition ?????????? ?????? ????

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

??????? ????

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

???????

???? ???????: 911022 - ????? ??? ??????: 21/????/1428 - ??????: 3.3
????? ???
  • Microsoft CRM 3.0
  • Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
????? ??????: 
kbmt kbautohotfix kbprint kbexport kbfix kbbug kbexpertisebeginner kbhotfixserver kbqfe kbmbsmigrate KB911022 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????911022
(http://support.microsoft.com/kb/911022/en-us/ )
???? ??? ?????? | ????? ???????

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

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