????? ???? SQL ??? ??? ?????? ????? ????? Insert ????? ?? BCP: "<loglock.cpp>? ??? = 807 ??? ??????? = ' ????? = = LCK_OK '"</loglock.cpp>

?????? ????????? ?????? ?????????
???? ???????: 2700641 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

???? ??? ????????? ??????:
  • ???? ?????? ???? a ? b ???? Microsoft SQL Server 2008 ?? SQL Server 2008 R2.
  • ???? ?????? ????? ?????? ????? ???????? ??? ???? a ? b ??????.
  • ????? ????? INSERT ????? ?? BCP ??? ????? ???????? ???????.

    ?????? ???? ???????? ??? ????? ?????? CHECK_CONSTRAINTS ??? ????? ??????? ????? ???? ?????? "????? ????" ?? ????? BCP.
  • ??? ????? ???????? ??????? ????? ????? ???????? ????? ???????? ???? ????? ??? ???? ?????.
?? ??? ?????????? ???? ????? ??? ???? ?????? ?????????. ????? ??? ????? ??? mini-dump ?? ???? ????? SQL Server. ???????? ??? ???? ???? ??? ??? ?? ??? ????? SQL Server ??? ?????? ???????:

??????? ????? spid ??????? ????? 'dbghelp.dll' ' 4.0.5 '
??????? ????? spid ** ????? ???? ???????-spid = 31? EC = 0x00000007F9B1C1A0
??????? ????? spid *** ????? ?????? ??? ??????? ??? Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0001.txt SQL ??????????: ????? ????????

??????? ????? spid * *******************************************************************************

??????? ????? spid *
??????? ????? spid * ????? ?????? BEGIN:
??????? ????? spid * 01/04/12 16: 46: 21 spid 12100
??????? ????? spid *
??????? ????? spid * ??????: loglock.cpp:807
??????? ????? spid * ?????: ???? = = LCK_OK
??????? ????? spid * SPID: 31
??????? ????? spid * ???? ???????: 2228

??????? ????? spid ???: 17066? ???????: ???? 16,: 1.

??????? ????? spid ????? ???? SQL: ???: <loglock.cpp>? ??? = 807 ??? ??????? = '????? = = LCK_OK'. ?? ???? ??? ????? ????? ??? ?????. ??? ????? ????? ??? ??????? ??????? ?????? DBCC CHECKDB ?????? ?? ????? ???????? ??????? ??????? ?? ????? ????? ?????? ?????? ?? ????? ???????? ?? ??????? ??? ??????.

</loglock.cpp>??????? ????? spid ???: 3624, ?????: ???? 20?: 1.

??????? ????? spid ??? ???? ????? ?? ????. ???? ?? ??? ??? SQL Server ?????? ??? ????????. ???? ???? ??? ????? ????? ?? ??? ????? ??? ?? ????????. ?????? ?? ???? ??? ?? ????? ????????? ???? ????? DBCC CHECKDB. ??? ????? ??? ????? ?????? ????? ??? Microsoft ????? ???????? ???? ????? ????? ???? ??? Microsoft. ?? ???? ??? ????????? ???????? ?? Microsoft ?? ???? "???? ????" ?? QFE ?? "????? ?????".

??????? ????? spid ???: 1454 ???????: ???? 16,: 1.

??????? ????? spid ??? ????? ??? ????? ????????. ???? ???? ?????? '<Instance name="">' ???? ????? 3624? 1? ??????? 20 ????? ??? ????? ???? ????? ?????? ?????? ???????? '<database name="">'. ?? ????? ????? ???????? ????? ???????? ??????? ??????? ???????? ?? ????? ??????? ????? ???????? ???? ?????. ?????? ??? ???? ?? ?????????? ??? ??? ????? ?????? ??? ??????. </database></Instance>


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

?????

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

???? ??????

?????? ??? ??? ???????? ????? ???? INSERT ????? ?? BCP ??? ????? ???????? ??????? ???????? ???? CHECK_CONSTRAINTS.

?????? ???? ???? CHECK_CONSTRAINTS ???? ????. ??? ???? ????? ??????? ??? ?????? ????????? ?? ???? ??????.

??????? ????

????? ????? ????? ????? ???? ?? BCP ?????? ??? ????? ????? ?????? CHECK_CONSTRAINTS. ?????? ??? ???????? ????? ????? ?????? ?? ????? ???????? ?????. ??? ????? ??????? ??????? ?? ??? ???????? ?? ????? ???????? ???????. ????? ??? ??? ??? ??????? ?????? ?????? ??? ????? ???????? ???????.

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

???????

???? ???????: 2700641 - ????? ??? ??????: 18/?????/1433 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 Enterprise
????? ??????: 
kbsurveynew kbtshoot kbprb kbmt KB2700641 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2700641

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

 

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