????? ??? FIX:: ???? "??????? ?????? ??????? ??? ????? ??????" ?? SQL Server 2000 SP3

?????? ????????? ?????? ?????????
???? ???????: 814893 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
CPR - SQL 2000 - ??????? ?????? ?? SP4
????? ???: 364087 (SHILOH_BUGS)
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ??? ????????? ???????
  • ??????? ?????? ?????? ??
    321541FIX: ?? ????? ???? SQL ??? ???? ??? ??????? ??? ?????? ???? ?????
    ??? ???? ??????? ???? ????? Microsoft SQL Server 2000 ?????? ????? ?????? Service Pack 2 (SP2).
  • ?????? ??????? ?????? ?????? ?? Microsoft Security Bulletin MS02-061 Microsoft SQL Server 2000 ?????? ????? ?????? SP2.
  • Microsoft SQL Server 2000 Service Pack 3 (SP3).
?? ????? ????? ????? ???????:
??????? ?????? ??????? ??? ????? ????? ?? ?????.

????

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ???????? ??????? coordinated (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
   Date         Time   Version        Size              File name
   ------------------------------------------------------------------
   08-Feb-2003  05:43                    786,432 bytes  Distmdl.ldf
   08-Feb-2003  05:43                  2,359,296 bytes  Distmdl.mdf
   01-Feb-2003  00:32  2000.80.763.0   1,557,052 bytes  Dtsui.dll        
   30-Jan-2003  05:18                    746,470 bytes  Instdist.sql
   08-Feb-2003  06:40  2000.80.765.0      90,692 bytes  Msgprox.dll      
   08-Feb-2003  03:53                  1,065,895 bytes  Replmerg.sql
   08-Feb-2003  06:40  2000.80.765.0     221,768 bytes  Replprov.dll     
   08-Feb-2003  06:40  2000.80.765.0     307,784 bytes  Replrec.dll      
   30-Jan-2003  05:18                  1,084,318 bytes  Replsys.sql
   08-Feb-2003  06:40  2000.80.765.0     176,696 bytes  Sqlmap70.dll     
   08-Feb-2003  06:40  2000.80.765.0      57,920 bytes  Sqlrepss.dll     
   15-Feb-2003  02:52  2000.80.769.0   7,512,145 bytes  Sqlservr.exe     
   15-Feb-2003  02:52                 12,715,008 bytes  Sqlservr.pdb
   08-Feb-2003  06:40  2000.80.765.0      45,644 bytes  Sqlvdi.dll       
   08-Feb-2003  06:40  2000.80.765.0      82,492 bytes  Ssnetlib.dll     
				
?????? ???? ?????? ?????? ???? ????? ???? ?? ?????? ???? ????? ??? ??????? ?? ????? ????? ??? ????? ??????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".?? ????? ??? ??????? ???? ??? ?? Microsoft SQL Server 2000 ?????? ????? ?????? Service Pack 4.

??????? ????

??????? ?????? ??? ???????? ?? ??? ??????? regresses ????? ?????? ?? ????? "????? ????? Microsoft" ???????:
321541FIX: SQL Server ?? ????? ????? ??? ????? ??? ??????? ??? ?????? ????


?????? ?????? ??????? ?????? ??? ???????? ?? ??? ??????? ????? ??? ????? ?????? ????? - T220 ? ?? ??? ????? SQL Server.

?????? ????? ???? ???? ??????? ???????:
  1. ???? ????? ??????? SQL ??? ??????.
  2. ???? ??? ?????? ???? ????? ???????.
  3. ???? ??? ?????? ?????? ??? ?????? ?? ???? ??? ?????.
  4. ?? ??????? ???? ???? ??? ??? ??????.
  5. ?? ???? ?????? ?????? ??? ??????? ???? -T220 ? ?? ???? ??? ?????.
  6. ???? ??? ?????.
  7. ????? ?? ?? ?????? ????? ???? Mssqlserver ??? ????? ????? SQL Server.

???? ?? ??????? ????? ???? ???? ??????? - T220.
?????? ?????? ?????? ????? ???? Test_Table1 ? Test_Table2. ?? ???? ???????? ????? ????? ???????? ???????:
CREATE TABLE TEST_TABLE1 ( 
[CODE] [int] NOT NULL PRIMARY KEY, 
[DESCRIPTION] [varchar] (50)) 

CREATE TABLE TEST_TABLE2 ( 
[CODE] [int] NOT NULL PRIMARY KEY, 
[DESCRIPTION] [varchar] (50)) 
go
CREATE VIEW dbo.TEST_VIEW 
AS 
SELECT CODE, 
UPPER(DESCRIPTION) AS DESCRIPTION, 
ISNULL(UPPER(DESCRIPTION), 'DEFAULT') DESCRIPTION_DEF 
FROM dbo.TEST_TABLE2 
go
?? ???? ?????? ??? ???????? ????????:
DECLARE cc CURSOR FOR 
SELECT TEST_TABLE1.CODE, TEST_VIEW.DESCRIPTION, TEST_VIEW.DESCRIPTION_DEF 
FROM TEST_TABLE1 LEFT OUTER JOIN TEST_VIEW 
ON TEST_VIEW.CODE = TEST_TABLE1.CODE 
FOR UPDATE
  • ?????? ??? ??????? SQL Server 2000 ??? SQL Server 2000 SP2 ?? ??????? ?????? ???? ??? ??????? ?? Microsoft Security Bulletin MS02-061 ????? ? ??? ????? ???????? ???????? ?????.
  • ????? ????????? SQL Server 2000 ??? SQL Server 2000 SP2 ?? ??????? ?????? ???? ??? ??????? ?? Microsoft Security Bulletin MS02-061 ????? ????????? ???????? ?? ??? ????? ?????.
  • ?????? ??? ??????? SQL Server 2000 8.00.0769 ????? ??????? ??? ??????? ????? ???? - traceon T220 ?? DBCC (220) ?? ????????? ???????? ?????.
???? ????? ?? ?? ???? ????? SELECT ??? ???????.
  • ?????? ??? ??????? SQL Server 2000 ??? SQL Server 2000 SP2 ?? ??????? ?? Microsoft Security Bulletin MS02-061 ????? ??????? ?????? ?????? ?? ??? 8.00.0769 ????? ???? 220 ? ????? ??????? ???:

    CODE        DESCRIPTION                                        DESCRIPTION_DEF                                    
    ----------- -------------------------------------------------- -------------------------------------------------- 
    1           NULL                                               DEFAULT
    
    
  • ?????? ??? ??????? SQL Server 2000 ??? SQL Server 2000 SP2 ?? ??????? ?????? ???? ??? ??????? ?? Microsoft Security Bulletin MS02-061 ?????? ????? ??????? ???:

    CODE        DESCRIPTION                                        DESCRIPTION_DEF                                    
    ----------- -------------------------------------------------- -------------------------------------------------- 
    1           NULL                                               NULL
    

???????

???? ???????: 814893 - ????? ??? ??????: 28/???? ??????/1435 - ??????: 4.2
????? ???
  • Microsoft SQL Server 2000 Service Pack 3
????? ??????: 
kbnosurvey kbarchive kbmt kbhotfixserver kbqfe kbqfe kbsqlserv2000presp4fix kbfix kbbug KB814893 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????814893

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