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

???? ID: 2678370 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???????? ?? ????? ????:
  • ?? Microsoft SQL Server 2012 ??? ????? ??????? ???? ????? ??????? ??????? predicate ?? ????? ???? ??, ?? ON_FAILURE ??? "FAIL_OPERATION ???? ?? ???." ?? ??? ??
  • ??? ?? ????? ??????? ?????????? ?? ????? ??????? ?? ??? ??????? ??????? ?????????? ??????
  • ??? ?? ???? ??????? ????? ?? ??????? ?????????
  • ???????? triggers ??????? ????? ?? ??????? ?????????? ??? ????????? ?? ?? ???
?? ???????? ???, ???????? ?? ??????? ?????????? ?? ???? ??? ??? ??, SQL ????? ?????? ??? ??? ????? ?????? ????? ??? ??? ???:

spid ## 'Dbghelp.dll' ??????? '4.0.5' ?? ?????

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

SqlDumpExceptionHandler: ????????? 51 ????? ????? ??????? c0000005 EXCEPTION_ACCESS_VIOLATION. SQL ????? ?? ????????? ?? ??? ?? ??? ???

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

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

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

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



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

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



????? ??????: 17310, Severity: 20, ??????: 1?

????? ?? ?????????? ?? ?????? SPID 51 ?? ??? ???? ?? ??? ????? ????? ???????? SQL ????? ?? ???? ?????? ???? ?? ??? ??? ??? ?? ??? ?????? ?????? ?????? ?????? ??? ?????????? ??? ??????? ???

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

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

?????? ????? SQL ????? ?????? ??? ??? ??? ?? ???, ?? ?????? ? ?? ???
????? ?? ???? ???? | ??????????? ???

????????

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

SQL ????? 2012

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

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

??????

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

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

?? ?????? ?? ?? ???? ?? ???, ????? ???????? ??? ?? ?? ?? ?? ????:
  • ??????? predicates ????? ? ?????
  • ??? ???? ON_FAILURE ??? ?? ?????? ???? ?? ??? "???? ????."
????? ?? ???? ???? | ??????????? ???

???? ???????

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

??????? ????? ???? ?? ?????? ???? ???, ?? ????? ???????? ???? ?? ???? ??? ??????? ????? ??????? ?????????, ???? SUCCESSFUL_LOGIN_GROUP, ??? ????????? ?????? ???????? ???? ?? ?????? ???? ??, ??????? ?? ??????? ??????? ?? ???? ?? _CHANGE_GROUP ???????? ?? audits ?? ????? ?? ???? ?? SQL ????? ???????????? ?? ??????? ?? ?? ?? ???? ?? ????? ???? (????, -f ????????? ???????? ?? ???)? Audits ?? "?????" ??? ??? ?????? ?????? ??????? ?? ???? ??? ?? ????? ???? ?? ??? ?? ????? ?????? ?? ????? ?? ???? ???:

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



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

???

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

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

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