FIX: ????? ????? CSV UNICODE Generates xp_sendmail

?????? ????????? ?????? ?????????
???? ???????: 280720 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 351089 (SHILOH_BUGS)
????? ???: 351894 (SHILOH_BUGS)
????? ???? | ?? ????

?? ??? ??????

???????

??? ??? ?????? ????? xp_sendmail ?? ??? ???? ?? SQL Server 2000 ?? ???? ??? ????? .csv ?? Microsoft Excel ?? Microsoft Word ?? ?? ????? ??? (???????? ???????) ? ?? ????? ????? ????? ??? ?? ???? ?????? ?????.

?????

???? SQL Server 2000 ?????? ????? ?? xp_sendmail ?????? UNICODE. ??? ????? ??????? ?????? ANSI ?? SQL Server 7.0.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000

???? ??????

??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
   Date           Version     Size     File name      Platform
   -------------------------------------------------------------
   Nov 21, 2000   8.00.0224   165 KB   Sqlmap70.dll   x86
				

?????

???? Microsoft ?? ??? ????? ?? SQL Server 2000. ?? ????? ??? ??????? ???? ??? ?? SQL Server 2000 Service Pack 1.

??????? ????

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

  1. ?? ?????? ????? ??????:
    execute	master..xp_sendmail
    	@recipients = 'user1',
        	@message = 'Testing',
        	@query = 'select * from sysobjects',
        	@width = 256,
        	@subject = 'testing',
        	@attach_results = 'true',
        	@no_header = 'false',
        	@separator = ',',
        	@attachments = 'test.csv'
    					
  2. ??? ???? ????? test.csv ?????? ??? ?? Excel ?? Word; ??? ????? ??? ?? ???? ?????? ????? ????? ?????.
  3. ???? ??? ??????? ?? SQL Server 7.0 ?? ???? ?? ?? ????? ?????.
??? ????? ??????? ?????? ?? ???? ??????? ??? ????? ????? ???????:
  • ??????? ?????????? ? @ ansi_attachment ? ??? ????? xp_sendmail. ???? ?? ???? ??? ??????? True (??????? ??? ??? ???? ANSI) ? False (??????? ??? ??? UNICODE) ?? ??? ?????. ??? ??? ??? ???????? ??? ????? ???? ????? ansi_attachment ?.
  • ??? ????? ????? ??????? ?????? ?????? ?????? Sqlmap70.dll ?? ???? ???? ??? ??? ??? ????? ???????? ANSI ?? Unicode.

    ?????? ?????????:
    HKLM\Software\Microsoft\MSSQLSERVER\SQLMAPI\ansi_attachment
    ??????? ????? ???????:
    Server\InstanceNameHere\SQLMAPI\ansi_attachment SQL HKLM\Software\Microsoft\Microsoft
  • ?? ???? ????? ????? ??????? ????? ???? ??????? ????? ?????? ????? ???????.?????: ???? ??????? "???? ???????" ?????? ??? ?????? ?? ???? ???? ?????? ????? ???? ????? ????? ???? ???????. ??? ???? Microsoft ?? ???????? ???? ???? ?? ??????? "???? ???????" ?????? ??? ?????. ?????? "???? ???????" ??? ???????? ??????.

    1. ??? ????? Regedt32.exe.
    2. ?????? ????????? ????? ??? HKLM\Software\Microsoft\MSSQLSERVER.
      ??????? ????? ??????? ????? ??? Server\InstanceNameHere SQL HKLM\Software\Microsoft.
    3. ????? ????? ???? ???? SQLMAPI.
    4. ???? ??? ???????.
    5. ?????? ???? ????? ???? ansi_attachment.
    6. ????? ??? ?????? REG_DWORD.
    7. ????? ?????? ??? 1 ??????? ANSI, 0 ??????? Unicode.

???????

???? ???????: 280720 - ????? ??? ??????: 21/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbqfe kbsqlserv2000sp1fix KB280720 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????280720

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

 

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