?????: ??? 17310 ??? ????? ????? ???? ???? ?????? ??? ????? ??????? ?? ?????? ????? ?? 2012 ???? SQL

???? ???????: 2678370 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ????? ????? ???? Microsoft SQL Server 2012. ????? ?????? ?????? ???? ????? ???? ?????? ??? ????? ??????? ON_FAILURE ??? "FAIL_OPERATION".
  • ????? ????? ??????? ????? ???? ?? ??????? ????? ????? ?????? ??????? ??????.
  • ????? ????? ??? ???? ????? ????????.
  • ???? ??????? ??? ????? ??????? ?? ??????? ???????.
?? ??? ?????????? ??? ??? ????? ???????. ???????? ??? ???? ??? ????? ????? ????? ??????? ?? ??? ????? SQL Server:

spid # # ??????? ????? 'dbghelp.dll' ' 4.0.5 '

spid # # *** ??? ??????? ??? C:\Program Files\Microsoft SQL Server\MSSQL11 ????? ??????.<InstanceName>\MSSQL\LOG\SQLDump0050.txt

????????????????????????: 51 ????? ????? ??????? ???? c0000005 EXCEPTION_ACCESS_VIOLATION. ??? ????? SQL Server ??? ???????.

*******************************************************************************

</InstanceName>spid # # * ????? ?????? ?????:

spid # # * 13/01/12 13: 48: 18 spid 51

spid # # * ????? ????????? = 0000000072B8D826 Module(UNKNOWN+0000000000000000)



spid # # * ??? ????????? = c0000005 EXCEPTION_ACCESS_VIOLATION

spid # # * ??? ?????? ???? ????? ????? 0000000000000000



??? ????: ????? 17310?: ???? 20?: 1.

??? ???????? a ???? ?? ???? ??? ?? SPID 51 ????? ??????? ????. ??? ????? SQL Server ???? ????? ???. ????? ??? ?????? ???? ??????? ?? ????? ??? ????? ???? ?????.

?????? ????? ??????? ????????? ?????? ?????? ?? ??? ???? ???????:

SELECT NAME AS AUDITNAME FROM SYS.SERVER_AUDITS WHERE ON_FAILURE = 2 AND PREDICATE IS NOT NULL

??? ??? ??? ????? ????? ??? ?? ??? ????? SQL Server? ???? ???????.
???? ??? ?????? | ????? ???????

????

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

???? SQL 2012

?? ????? ????? ??? ??????? ???? ??? ?? ??????? ???????? 1. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???? ??????? ????????? ? SQL Server 2012? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
2679368
(http://support.microsoft.com/kb/2679368/ )
???? ??????? ???????? 1 ? SQL Server 2012
?????? ????? ???? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? 2012 ???? SQL ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
2692828
(http://support.microsoft.com/kb/2692828/ )
???? 2012 ???? SQL ???? ?? ??????? ??? ????? SQL Server 2012

???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

???? ??????

?????? ??? ??? ???????? ?? ???? ????????? ???????:
  • ?? ?????? ????? ??????? ???? ???????.
  • ????? ON_FAILURE ????? ???????? ??? "??????".
???? ??? ?????? | ????? ???????

??????? ????

?????? ??? ???? ?? ????????? ??? SQL Server ???????? ?? ?????? ???? ??? Microsoft Developer Network (MSDN) ???????:
??????? ???? ??? ??????? SQL Server
(http://msdn.microsoft.com/en-us/library/cc280386.aspx)

??? ????? ????? ???????? ?? ???? ????? ?????. ?? ???? ??? ??????? ??? ???????? ????? ??? ??????? "??????? ?????" ??????? ?? ??????? ??????? ??????? ??? SUCCESSFUL_LOGIN_GROUP? _CHANGE_GROUP ???????. ???? ????? ??? ????????? ?? ??????? ??? ????? ??? ????? SQL Server ??? ????? ???? ?????? (??? ???????? ?????? ??? ??????? -f ). ????? ??????? ????????? ?????? ?????? ??????? ???? ???? ?? ???? ??????? ??????? ?? ??? "???????":

SELECT name as AuditName FROM sys.server_auditsWHERE on_failure = 2 AND predicate IS NOT NULL



???? ??? ?????? | ????? ???????

???????

???? ???????: 2678370 - ????? ??? ??????: 26/????? ??????/1433 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
????? ??????: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew kbmt KB2678370 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2678370
(http://support.microsoft.com/kb/2678370/en-us/ )
???? ??? ?????? | ????? ???????

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

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