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

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

?? ????? ??

?????

????? ??? ?? ?? ???? ???? ?? ???
  • ???????? ??? ????? ???? ???
    321541FIX: SQL Server ?? ???? ?? ???? ??? ?????? ???? ?? ?? ???? Outer ?????? ?? ???? ????? ?? ?????
    ???? ???????? ?? ?? Microsoft SQL Server 2000 ?????? ??? 2 (SP2) ?? ??? ???
  • ??????? ???????? ??? ????? ???? ???Microsoft ??????? ??????? MS02-061Microsoft SQL Server 2000 SP2 ?? ????
  • Microsoft SQL Server 2000 ?????? ??? 3 (SP3)?
???? ????? ?????? ????? ??????? ?? ???? ??:
????????? ????? ????? ??????? ?????? ?? ??? ??? ?? ???? ???? ?? ??? ???

????????

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

?? ?????? ?? ?? ???? ?? ??? Microsoft SQL Server 2000 ?? ??? ?????? ?????? ??? ??????? ????? ???????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
290211?????? SQL Server 2000 ?????? ??? ?? ??????? ???? ?? ??? ???? ????

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

?? ????????? ?? ????????? ??????? ??? ?? ????? ????????? (?? ??? ?? ????? ?????????) ??? ?? ????? ?????? ??? ???????? ???.. ?? ??????? ?? ??? ?????? ?? ???, ??????? ????????? ??? (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 ?????? ??? 4 ??? ??? ???? ??? ???

???? ???????

???????? discussed ?? ???? ??? ????? Microsoft ???????? ???? ??? discussed ????? regresses ??:
321541FIX: SQL Server ?? ???? ?? ???? ??? ?????? ?? ?? ???? Outer ?????? ?? ???? ????? ?? ?????


???:???????? operational ?? ???? ??? discussed ???? ?? ???, ?? ????? ????? ???? - T220, ????? ???? ?? ???????? SQL Server ?????

????? ????? ?? ????? ???? ?? ??? ????? ????? ?? ???? ????:
  1. ????? ?? SQL ?????????? ??????? ?? ??????
  2. ?????? ?? ????? ?? ??? ?? ?? ????? ?? ??? ???? ?? ??? ????? ?????
  3. ????? ?? ????-????? ????, ?? ???? ??????.
  4. ????? ?????????????? ??,????????? ????????.
  5. ?????????????? ????????????? ????? ???, ??????-T220?? ????-????? ????, ?? ???? ???add.
  6. ????? ????,OK.
  7. ??? ????, ?? ??? SQL ????? ?? ???????? ???? ?? ??? Mssqlserver ???? ?? ???????? ?????

?????? ?? ?? ?????? ?? ???-?? ????? ???? - 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
  • ??? discussed ??????? ???????? ?? ??? SQL Server 2000 SP2, ???? ?? ???? SQL Server 2000 ??????? ?? ???Microsoft ??????? ??????? MS02-061??????? ???? ??, ??? ???? ??????????? ???
  • ??? SQL Server 2000 ??????? SQL Server 2000 SP2, ??? ??? discussed ??????? ???????? ?? ??? ?? ???Microsoft ??????? ??????? MS02-061??????? ???? ??, ??? ???? ???? ????????????
  • 8.00.0769 SQL Server 2000 ??????? ?? ??? ?? ??? ???, ?? ?? ????? ???? - T220 ?? DBCC traceon (220), ??? ????? ???? ??????????? ???
?? ??? ?? ??? ??? ???? ???? ?? ?????? ???
  • ??? discussed ??????? ???????? ?? ??? SQL Server 2000 SP2, ???? ?? ???? SQL Server 2000 ??????? ?? ???Microsoft ??????? ??????? MS02-061??????? ???? ??, ?? ?????? 8.00.0769 ????? ???? 220 ?? ???, ?????? ?? ???? ???? ??:

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

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

???

???? ID: 814893 - ????? ???????: 26 ????? 2014 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2000 Service Pack 3
??????: 
kbnosurvey kbarchive kbHotfixServer kbqfe kbsqlserv2000presp4fix kbfix kbbug kbmt KB814893 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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