FIX: ????? ???? ????? ?? ?????? ?????? ???? ?????? ???? ??? ????? ????? ?? ???? ????? ?????

?????? ????????? ?????? ?????????
???? ???????: 286749 - ??? ???????? ???? ????? ????? ??? ???????.
BUG #: 351939 (SHILOH_bugs)
????? ???? | ?? ????

???????

??? ??? ?????? ? ????? ????, ????? ???? ? ????? ???? ?? ??????, ????? ???????? ?? ????? ??? ? CHECKTABLE DBCC ??????? ?? ?????? ???????. ?? CHECKTABLE DBCC ?????? ????? ??????:
????: ????? 8970 ? ????? 16 ???? 1? ???? 2
?? ???: ???? ???? 2041058307 ? ????? ???? 0 ? ?????? ????? (1:77) ? ???? ???? 0. ?? ????? ?????? 'LastModified' ??? ????? ????? ????? ?? ????.
????: ????? 8970 ? ????? 16 ???? 1? ???? 2
?? ???: ???? ???? 2041058307 ? ????? ???? 0 ? ?????? ????? (1:77) ? ???? 1 ????. ?? ????? ?????? 'LastModified' ??? ????? ????? ????? ?? ????.
????: ????? 8970 ? ????? 16 ???? 1? ???? 2
?? ???: ???? ???? 2041058307 ? ????? ???? 0 ? ?????? ????? (1:77) ? ???? 2 ????. ?? ????? ?????? 'LastModified' ??? ????? ????? ????? ?? ????.
????? DBCC 'TableX_____________________________000000000011 #'.
???? ???? 0 ?? ????? 1 ????? 'TableX______________________________________________000000000011 #'.
CHECKTABLE ?????? ??? ????? ????? 0 ???????? ??????? 3 ?? ???? '# TableX________________________000000000011' (???? ???? 2041058307).
?? repair_allow_data_loss ??????? ?????? ????? ????? ?????? ????? ?????? CHECKTABLE DBCC (tempdb.dbo.#TableX________________________________________000000000011).

??? ????? ????? ?????? ??? ??? ?? ??? ????? SQL Server:
(tempdb.dbo.#TableX______________________________000000000011) ???? ??? ??????? ?????? <domain>\<user> ?????? ??? ????? 3 ? ????? ????? 0.

????

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

???? ??????

?????? ??? ??? ???????? ?????? ???? ????? ???????:
  • ????? ?????? ??? ????? ????????.
  • ????? ???? ?? ?????? ??? ????? ?????? ?? ??? ????? ????????.
  • ????? ???? ?? ?????? ??? ????? ???????? ???? ????? ?????.

?????

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

??????? ????

????? ????? ???????, ?? ?????? ???????? ????? ??????:
begin tran
create table #TableX (Col1 varchar(20))
insert #TableX values ('A')
insert #TableX values ('B')
insert #TableX values ('C')
create index ix_Col1 on #TableX(Col1)  -- works fine when this is moved after the commit
--insert #TableX values ('D') -- or when this is uncommented
commit

--insert #TableX values ('D') -- or when this is uncommented

alter table #TableX add LastModified datetime not null constraint cn_Enabled default getdate()
go
select * from #TableX
dbcc checktable(#TableX)
go
drop table #TableX
				

???????

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

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

 

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