Sample Header Ad - 728x90

Database Administrators

Q&A for database professionals who wish to improve their database skills

Latest Questions

1 votes
1 answers
7076 views
SQL Server is terminating this session. c0000005 EXCEPTION_ACCESS_VIOLATION
I Got Error: >A user request from the session with SPID 183 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. When I manually run the stored procedure it works ok, this one time got this error. Any idea...
I Got Error: >A user request from the session with SPID 183 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. When I manually run the stored procedure it works ok, this one time got this error. Any idea what can cause it and how to prevent it? Can someone explain what should I look for in the Dump File?
Microsoft SQL Server Enterprise (64-bit) Version 15.0.2080.9

SQL Dump Log: (Had to cut part of the last part of the Dump due to characters limitation)
. This is an informational message only. No user action is required.
2022-05-26 04:46:58.08 Backup      BACKUP DATABASE successfully processed 6689 pages in 1.556 seconds (33.580 MB/sec).
2022-05-26 04:47:10.65 Backup      Database backed up. Database: MaltaExperience, creation date(time): 2020/07/20(10:20:33), pages dumped: 755, first LSN: 314:106:1, last LSN: 314:109:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\MaltaExperience_20220526_0447.bak'}). This is an informational message only. No user action is required.
2022-05-26 04:47:10.66 Backup      BACKUP DATABASE successfully processed 745 pages in 0.197 seconds (29.512 MB/sec).
2022-05-26 04:47:14.82 Backup      Database backed up. Database: OMNIS_DW, creation date(time): 2019/11/18(12:21:57), pages dumped: 21770, first LSN: 829:515:1, last LSN: 829:518:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\OMNIS_DW_20220526_0447.bak'}). This is an informational message only. No user action is required.
2022-05-26 04:47:14.84 Backup      BACKUP DATABASE successfully processed 21617 pages in 1.457 seconds (115.906 MB/sec).
2022-05-26 04:47:23.26 Backup      Database backed up. Database: STL_DEVELOPERTOOLS, creation date(time): 2019/12/03(18:53:01), pages dumped: 714, first LSN: 59:3426:1, last LSN: 59:3429:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\STL_DEVELOPERTOOLS_20220526_0447.bak'}). This is an informational message only. No user action is required.
2022-05-26 04:47:23.28 Backup      BACKUP DATABASE successfully processed 705 pages in 0.107 seconds (51.415 MB/sec).
2022-05-26 04:47:34.52 Backup      Database backed up. Database: W6_BMIT, creation date(time): 2020/07/28(11:59:10), pages dumped: 74251, first LSN: 27089:468:1, last LSN: 27089:471:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\W6_BMIT_20220526_0447.bak'}). This is an informational message only. No user action is required.
2022-05-26 04:47:34.54 Backup      BACKUP DATABASE successfully processed 74025 pages in 8.780 seconds (65.867 MB/sec).
2022-05-26 04:56:37.18 Backup      Database backed up. Database: W6_FB_KC_BMIT, creation date(time): 2020/07/27(20:48:58), pages dumped: 6268300, first LSN: 707616:301:1, last LSN: 707616:304:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\W6_FB_KC_BMIT_20220526_0447.bak'}). This is an informational message only. No user action is required.
2022-05-26 04:56:37.19 Backup      BACKUP DATABASE successfully processed 6268265 pages in 527.577 seconds (92.822 MB/sec).
2022-05-26 05:02:43.66 Backup      Database backed up. Database: hMailServer, creation date(time): 2021/04/14(11:58:22), pages dumped: 651, first LSN: 108:12495:1, last LSN: 108:12498:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\hMailServer_20220526_0402.bak'}). This is an informational message only. No user action is required.
2022-05-26 05:02:43.71 Backup      BACKUP DATABASE successfully processed 641 pages in 0.204 seconds (24.516 MB/sec).
2022-05-26 05:02:46.28 Backup      Database backed up. Database: RT_ILLY, creation date(time): 2020/11/27(16:16:32), pages dumped: 955, first LSN: 47:12768:1, last LSN: 47:12771:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\RT_ILLY_20220526_0402.bak'}). This is an informational message only. No user action is required.
2022-05-26 05:02:46.30 Backup      BACKUP DATABASE successfully processed 945 pages in 0.153 seconds (48.212 MB/sec).
2022-05-26 05:02:48.96 Backup      Database backed up. Database: W6_SO_DEMO, creation date(time): 2021/12/02(15:50:03), pages dumped: 723, first LSN: 46:3173:1, last LSN: 46:3176:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\W6_SO_DEMO_20220526_0402.bak'}). This is an informational message only. No user action is required.
2022-05-26 05:02:48.98 Backup      BACKUP DATABASE successfully processed 713 pages in 0.133 seconds (41.834 MB/sec).
2022-05-26 05:02:51.45 Backup      Database backed up. Database: W6_SO_ILLY, creation date(time): 2021/12/02(15:51:04), pages dumped: 803, first LSN: 48:9130:1, last LSN: 48:9133:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\BACKUP\SQL_DAILY_BACKUP\W6_SO_ILLY_20220526_0402.bak'}). This is an informational message only. No user action is required.
2022-05-26 05:02:51.47 Backup      BACKUP DATABASE successfully processed 793 pages in 0.128 seconds (48.351 MB/sec).
2022-05-26 06:30:01.21 spid183     CImageHelper::Init () Version-specific dbghelp.dll is not used
2022-05-26 06:30:01.24 spid183     ***Stack Dump being sent to F:\SQL\MSSQL15.MSSQLSERVER\MSSQL\LOG\SQLDump2803.txt
2022-05-26 06:30:01.24 spid183     SqlDumpExceptionHandler: Process 183 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2022-05-26 06:30:01.24 spid183     * *******************************************************************************
2022-05-26 06:30:01.24 spid183     *
2022-05-26 06:30:01.24 spid183     * BEGIN STACK DUMP:
2022-05-26 06:30:01.24 spid183     *   05/26/22 06:30:01 spid 183
2022-05-26 06:30:01.24 spid183     *
2022-05-26 06:30:01.24 spid183     *
2022-05-26 06:30:01.24 spid183     *   Exception Address = 00007FFC96483D83 Module(sqllang+0000000000903D83)
2022-05-26 06:30:01.24 spid183     *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
2022-05-26 06:30:01.24 spid183     *   Access Violation occurred reading address 000001EAC188A000
2022-05-26 06:30:01.24 spid183     * Input Buffer 218 bytes -
2022-05-26 06:30:01.24 spid183     *             exec [spr_X_BOB_ExportAndEmail_v4] 32, 32026    exec [spr_X_S
2022-05-26 06:30:01.24 spid183     *  UMMARY_ExportAndEmail_v2] 32, 32026  
2022-05-26 06:30:01.24 spid183     *  
2022-05-26 06:30:01.24 spid183     *
2022-05-26 06:30:01.24 spid183     *  MODULE                          BASE      END       SIZE
2022-05-26 06:30:01.24 spid183     * sqlservr                       00007FF789CF0000  00007FF789D8DFFF  0009e000
2022-05-26 06:30:01.24 spid183     * ntdll                          00007FFCAC280000  00007FFCAC46CFFF  001ed000
2022-05-26 06:30:01.24 spid183     * KERNEL32                       00007FFCAB950000  00007FFCABA03FFF  000b4000
2022-05-26 06:30:01.24 spid183     * KERNELBASE                     00007FFCA8950000  00007FFCA8BE3FFF  00294000
2022-05-26 06:30:01.24 spid183     * apphelp                        00007FFCA6480000  00007FFCA650BFFF  0008c000
2022-05-26 06:30:01.24 spid183     * CRYPT32                        00007FFCA86A0000  00007FFCA8894FFF  001f5000
2022-05-26 06:30:01.24 spid183     * ucrtbase                       00007FFCA8310000  00007FFCA8409FFF  000fa000
2022-05-26 06:30:01.24 spid183     * MSASN1                         00007FFCA8260000  00007FFCA8271FFF  00012000
2022-05-26 06:30:01.24 spid183     * ADVAPI32                       00007FFCA9EF0000  00007FFCA9F96FFF  000a7000
2022-05-26 06:30:01.24 spid183     * msvcrt                         00007FFCA9CD0000  00007FFCA9D6DFFF  0009e000
2022-05-26 06:30:01.24 spid183     * sechost                        00007FFCABF90000  00007FFCAC02EFFF  0009f000
2022-05-26 06:30:01.24 spid183     * RPCRT4                         00007FFCAC120000  00007FFCAC23CFFF  0011d000
2022-05-26 06:30:01.24 spid183     * ole32                          00007FFCA99F0000  00007FFCA9B45FFF  00156000
2022-05-26 06:30:01.24 spid183     * combase                        00007FFCA94B0000  00007FFCA97DCFFF  0032d000
2022-05-26 06:30:01.24 spid183     * bcryptPrimitives               00007FFCA8BF0000  00007FFCA8C71FFF  00082000
2022-05-26 06:30:01.24 spid183     * GDI32                          00007FFCAC030000  00007FFCAC058FFF  00029000
2022-05-26 06:30:01.24 spid183     * gdi32full                      00007FFCA8500000  00007FFCA869BFFF  0019c000
2022-05-26 06:30:01.24 spid183     * msvcp_win                      00007FFCA8460000  00007FFCA84FFFFF  000a0000
2022-05-26 06:30:01.24 spid183     * USER32                         00007FFCAB7B0000  00007FFCAB946FFF  00197000
2022-05-26 06:30:01.24 spid183     * win32u                         00007FFCA8C80000  00007FFCA8C9FFFF  00020000
2022-05-26 06:30:01.24 spid183     * NETAPI32                       00007FFC9FCD0000  00007FFC9FCE8FFF  00019000
2022-05-26 06:30:01.24 spid183     * pdh                            00007FFCA48C0000  00007FFCA490CFFF  0004d000
2022-05-26 06:30:01.24 spid183     * SQLOS                          00007FFC9C2B0000  00007FFC9C2B7FFF  00008000
2022-05-26 06:30:01.24 spid183     * sqlmin                         00007FFC98220000  00007FFC9B1ECFFF  02fcd000
2022-05-26 06:30:01.24 spid183     * WS2_32                         00007FFCAB740000  00007FFCAB7ACFFF  0006d000
2022-05-26 06:30:01.24 spid183     * OLEAUT32                       00007FFCA9C00000  00007FFCA9CC3FFF  000c4000
2022-05-26 06:30:01.24 spid183     * sqlTsEs                        00007FFC952B0000  00007FFC95B79FFF  008ca000
2022-05-26 06:30:01.24 spid183     * sqldk                          00007FFC94D80000  00007FFC952A7FFF  00528000
2022-05-26 06:30:01.24 spid183     * opends60                       00007FFC94D70000  00007FFC94D78FFF  00009000
2022-05-26 06:30:01.24 spid183     * qds                            00007FFC94C40000  00007FFC94D67FFF  00128000
2022-05-26 06:30:01.24 spid183     * svl                            00007FFC94C10000  00007FFC94C3CFFF  0002d000
2022-05-26 06:30:01.24 spid183     * MSVCP140                       00007FFCA03C0000  00007FFCA0450FFF  00091000
2022-05-26 06:30:01.24 spid183     * MPR                            00007FFCA0690000  00007FFCA06AAFFF  0001b000
2022-05-26 06:30:01.24 spid183     * VCRUNTIME140                   00007FFCA0310000  00007FFCA0328FFF  00019000
2022-05-26 06:30:01.24 spid183     * Secur32                        00007FFCA24D0000  00007FFCA24DBFFF  0000c000
2022-05-26 06:30:01.24 spid183     * WINHTTP                        00007FFCA4740000  00007FFCA4830FFF  000f1000
2022-05-26 06:30:01.24 spid183     * sqllang                        00007FFC95B80000  00007FFC98177FFF  025f8000
2022-05-26 06:30:01.25 spid183     * secforwarder                   00007FFC94BF0000  00007FFC94C00FFF  00011000
2022-05-26 06:30:01.25 spid183     * bcrypt                         00007FFCA8CA0000  00007FFCA8CC5FFF  00026000
2022-05-26 06:30:01.25 spid183     * ODBC32                         00007FFC94B30000  00007FFC94BE4FFF  000b5000
2022-05-26 06:30:01.25 spid183     * WINTRUST                       00007FFCA8CD0000  00007FFCA8D30FFF  00061000
2022-05-26 06:30:01.25 spid183     * WINMM                          00007FFCA0390000  00007FFCA03B3FFF  00024000
2022-05-26 06:30:01.25 spid183     * VCRUNTIME140_1                 00007FFCA0B90000  00007FFCA0B9BFFF  0000c000
2022-05-26 06:30:01.25 spid183     * ncrypt                         00007FFCA7D00000  00007FFCA7D25FFF  00026000
2022-05-26 06:30:01.25 spid183     * USERENV                        00007FFCA8140000  00007FFCA8168FFF  00029000
2022-05-26 06:30:01.25 spid183     * profapi                        00007FFCA8280000  00007FFCA82A3FFF  00024000
2022-05-26 06:30:01.25 spid183     * WININET                        00007FFC93C00000  00007FFC940E0FFF  004e1000
2022-05-26 06:30:01.25 spid183     * XmlLite                        00007FFCA1E80000  00007FFCA1EB9FFF  0003a000
2022-05-26 06:30:01.25 spid183     * AUTHZ                          00007FFCA7310000  00007FFCA735BFFF  0004c000
2022-05-26 06:30:01.25 spid183     * WINMMBASE                      00007FFCA0330000  00007FFCA035CFFF  0002d000
2022-05-26 06:30:01.25 spid183     * cfgmgr32                       00007FFCA8410000  00007FFCA8459FFF  0004a000
2022-05-26 06:30:01.25 spid183     * dhcpcsvc                       00007FFCA4AF0000  00007FFCA4B0BFFF  0001c000
2022-05-26 06:30:01.25 spid183     * NSI                            00007FFCAA230000  00007FFCAA237FFF  00008000
2022-05-26 06:30:01.25 spid183     * NETUTILS                       00007FFCA7780000  00007FFCA778DFFF  0000e000
2022-05-26 06:30:01.25 spid183     * NTASN1                         00007FFCA7CC0000  00007FFCA7CFBFFF  0003c000
2022-05-26 06:30:01.25 spid183     * SSPICLI                        00007FFCA8170000  00007FFCA819EFFF  0002f000
2022-05-26 06:30:01.25 spid183     * DPAPI                          00007FFCA8030000  00007FFCA8039FFF  0000a000
2022-05-26 06:30:01.25 spid183     * LOGONCLI                       00007FFCA7860000  00007FFCA78A1FFF  00042000
2022-05-26 06:30:01.25 spid183     * SAMCLI                         00007FFCA4D60000  00007FFCA4D77FFF  00018000
2022-05-26 06:30:01.25 spid183     * psapi                          00007FFCA9D70000  00007FFCA9D77FFF  00008000
2022-05-26 06:30:01.25 spid183     * kernel.appcore                 00007FFCA8240000  00007FFCA8250FFF  00011000
2022-05-26 06:30:01.25 spid183     * instapi150                     00007FFC926E0000  00007FFC926F2FFF  00013000
2022-05-26 06:30:01.25 spid183     * CRYPTSP                        00007FFCA8D40000  00007FFCA8D56FFF  00017000
2022-05-26 06:30:01.25 spid183     * rsaenh                         00007FFCA75B0000  00007FFCA75E2FFF  00033000
2022-05-26 06:30:01.25 spid183     * CRYPTBASE                      00007FFCA7C00000  00007FFCA7C0BFFF  0000c000
2022-05-26 06:30:01.25 spid183     * imagehlp                       00007FFCABA10000  00007FFCABA2CFFF  0001d000
2022-05-26 06:30:01.25 spid183     * gpapi                          00007FFCA6E80000  00007FFCA6EA1FFF  00022000
2022-05-26 06:30:01.25 spid183     * wkscli                         00007FFCA37E0000  00007FFCA37F7FFF  00018000
2022-05-26 06:30:01.25 spid183     * cscapi                         00007FFC91F70000  00007FFC91F81FFF  00012000
2022-05-26 06:30:01.25 spid183     * sqlevn70                       000001D105470000  000001D1057A9FFF  0033a000
2022-05-26 06:30:01.25 spid183     * CLUSAPI                        00007FFC9DFD0000  00007FFC9E0D9FFF  0010a000
2022-05-26 06:30:01.25 spid183     * DNSAPI                         00007FFCA7790000  00007FFCA7855FFF  000c6000
2022-05-26 06:30:01.25 spid183     * IPHLPAPI                       00007FFCA7740000  00007FFCA777DFFF  0003e000
2022-05-26 06:30:01.25 spid183     * RESUTILS                       00007FFC9E0E0000  00007FFC9E17DFFF  0009e000
2022-05-26 06:30:01.25 spid183     * VERSION                        00007FFCA24F0000  00007FFCA24F9FFF  0000a000
2022-05-26 06:30:01.25 spid183     * hkruntime                      00007FFC89B70000  00007FFC89E42FFF  002d3000
2022-05-26 06:30:01.25 spid183     * dbghelp                        00007FFCA35B0000  00007FFCA379CFFF  001ed000
2022-05-26 06:30:01.25 spid183     * hkcompile                      00007FFC89980000  00007FFC89ABFFFF  00140000
2022-05-26 06:30:01.25 spid183     * hkengine                       00007FFC89280000  00007FFC89975FFF  006f6000
2022-05-26 06:30:01.25 spid183     * SHLWAPI                        00007FFCAC0C0000  00007FFCAC111FFF  00052000
2022-05-26 06:30:01.25 spid183     * ncryptprov                     00007FFCA0AE0000  00007FFCA0B39FFF  0005a000
2022-05-26 06:30:01.25 spid183     * msv1_0                         00007FFCA79B0000  00007FFCA7A26FFF  00077000
2022-05-26 06:30:01.25 spid183     * NtlmShared                     00007FFCA79A0000  00007FFCA79ACFFF  0000d000
2022-05-26 06:30:01.25 spid183     * cryptdll                       00007FFCA7AA0000  00007FFCA7AB4FFF  00015000
2022-05-26 06:30:01.25 spid183     * kerberos                       00007FFCA7AF0000  00007FFCA7BF3FFF  00104000
2022-05-26 06:30:01.25 spid183     * schannel                       00007FFCA74E0000  00007FFCA7563FFF  00084000
2022-05-26 06:30:01.25 spid183     * SECURITY                       000001D78EFE0000  000001D78EFE2FFF  00003000
2022-05-26 06:30:01.25 spid183     * MSCOREE                        00007FFC9B6B0000  00007FFC9B713FFF  00064000
2022-05-26 06:30:01.25 spid183     * mscoreei                       00007FFC98180000  00007FFC9821BFFF  0009c000
2022-05-26 06:30:01.25 spid183     * SqlServerSpatial150            00007FFC8ACF0000  00007FFC8AD91FFF  000a2000
2022-05-26 06:30:01.25 spid183     * clbcatq                        00007FFCA9B50000  00007FFCA9BF1FFF  000a2000
2022-05-26 06:30:01.25 spid183     * msxml3                         00007FFC8AAB0000  00007FFC8ACEAFFF  0023b000
2022-05-26 06:30:01.25 spid183     * ualapi                         00007FFCA0FA0000  00007FFCA0FB9FFF  0001a000
2022-05-26 06:30:01.25 spid183     * SHELL32                        00007FFCAA240000  00007FFCAB738FFF  014f9000
2022-05-26 06:30:01.25 spid183     * shcore                         00007FFCA97E0000  00007FFCA9887FFF  000a8000
2022-05-26 06:30:01.25 spid183     * ESENT                          00007FFCA0C70000  00007FFCA0F92FFF  00323000
2022-05-26 06:30:01.25 spid183     * ntmarta                        00007FFCA71F0000  00007FFCA7220FFF  00031000
2022-05-26 06:30:01.25 spid183     * windows.storage                00007FFCA8D60000  00007FFCA94A7FFF  00748000
2022-05-26 06:30:01.25 spid183     * powrprof                       00007FFCA82B0000  00007FFCA830CFFF  0005d000
2022-05-26 06:30:01.25 spid183     * msoledbsql                     00007FFC8A7E0000  00007FFC8AA54FFF  00275000
2022-05-26 06:30:01.25 spid183     * COMDLG32                       00007FFCA9890000  00007FFCA99B6FFF  00127000
2022-05-26 06:30:01.25 spid183     * COMCTL32                       00007FFC8A730000  00007FFC8A7D8FFF  000a9000
2022-05-26 06:30:01.25 spid183     * MSOLEDBSQLR                    000001D791460000  000001D791481FFF  00022000
2022-05-26 06:30:01.25 spid183     * dhcpcsvc6                      00007FFCA4B90000  00007FFCA4BA5FFF  00016000
2022-05-26 06:30:01.25 spid183     * sqlncli11                      00007FFC8A3D0000  00007FFC8A722FFF  00353000
2022-05-26 06:30:01.25 spid183     * MSVCR100                       0000000074D40000  0000000074E11FFF  000d2000
2022-05-26 06:30:01.25 spid183     * SQLNCLIR11                     000001D7914C0000  000001D7914F7FFF  00038000
2022-05-26 06:30:01.25 spid183     * netbios                        00007FFC8D7F0000  00007FFC8D7FBFFF  0000c000
2022-05-26 06:30:01.25 spid183     * sqlnclirda11                   00000000749E0000  0000000074D38FFF  00359000
2022-05-26 06:30:01.25 spid183     * SQLNCLIRDAR11                  000001D791510000  000001D791547FFF  00038000
2022-05-26 06:30:01.25 spid183     * clr                            00007FFC940F0000  00007FFC94B2AFFF  00a3b000
2022-05-26 06:30:01.25 spid183     * MSVCR120_CLR0400               00007FFC93B00000  00007FFC93BF6FFF  000f7000
2022-05-26 06:30:01.25 spid183     * clrjit                         00007FFC9B370000  00007FFC9B49AFFF  0012b000
2022-05-26 06:30:01.25 spid183     * BatchParser                    00007FFC8A3A0000  00007FFC8A3C9FFF  0002a000
2022-05-26 06:30:01.25 spid183     * SqlAccess                      00007FFC8A320000  00007FFC8A395FFF  00076000
2022-05-26 06:30:01.25 spid183     * SRVCLI                         00007FFC9FCF0000  00007FFC9FD15FFF  00026000
2022-05-26 06:30:01.25 spid183     * ftimport                       0000000060000000  0000000060024FFF  00025000
2022-05-26 06:30:01.25 spid183     * MSFTE                          0000000049980000  0000000049D2DFFF  003ae000
2022-05-26 06:30:01.25 spid183     * mskeyprotect                   00007FFC9B4A0000  00007FFC9B4B4FFF  00015000
2022-05-26 06:30:01.25 spid183     * mswsock                        00007FFCA7A30000  00007FFCA7A96FFF  00067000
2022-05-26 06:30:01.25 spid183     * ntdsapi                        00007FFCA1550000  00007FFCA1577FFF  00028000
2022-05-26 06:30:01.25 spid183     * DSPARSE                        00007FFCA24C0000  00007FFCA24CCFFF  0000d000
2022-05-26 06:30:01.25 spid183     * rasadhlp                       00007FFCA2BF0000  00007FFCA2BF9FFF  0000a000
2022-05-26 06:30:01.25 spid183     * fwpuclnt                       00007FFCA4B10000  00007FFCA4B88FFF  00079000
2022-05-26 06:30:01.25 spid183     * ncryptsslp                     00007FFC9B580000  00007FFC9B5A3FFF  00024000
2022-05-26 06:30:01.25 spid183     * xpsqlbot                       00007FFC89FA0000  00007FFC89FA9FFF  0000a000
2022-05-26 06:30:01.25 spid183     * xpstar                         00007FFC89F20000  00007FFC89F91FFF  00072000
2022-05-26 06:30:01.25 spid183     * SQLSCM                         00007FFC8A2C0000  00007FFC8A2D3FFF  00014000
2022-05-26 06:30:01.25 spid183     * xpstar                         000001D79C2D0000  000001D79C2DCFFF  0000d000
2022-05-26 06:30:01.25 spid183     * SAMLIB                         00007FFC9FF10000  00007FFC9FF34FFF  00025000
2022-05-26 06:30:01.25 spid183     * Sort00060101                   00007FFCA2630000  00007FFCA2642FFF  00013000
2022-05-26 06:30:01.25 spid183     * System.Data                    00007FFC88BA0000  00007FFC88F07FFF  00368000
2022-05-26 06:30:01.25 spid183     * System.Transactions            00007FFC88B50000  00007FFC88B9EFFF  0004f000
2022-05-26 06:30:01.25 spid183     * xplog70                        00007FFCA4180000  00007FFCA4195FFF  00016000
2022-05-26 06:30:01.25 spid183     * xplog70                        000001D79D0A0000  000001D79D0A3FFF  00004000
2022-05-26 06:30:01.25 spid183     * oledb32                        00007FFC8AED0000  00007FFC8AFBCFFF  000ed000
2022-05-26 06:30:01.25 spid183     * MSDART                         00007FFCA26B0000  00007FFCA26D6FFF  00027000
2022-05-26 06:30:01.25 spid183     * Comctl32                       00007FFC85500000  00007FFC85778FFF  00279000
2022-05-26 06:30:01.25 spid183     * comsvcs                        00007FFC937D0000  00007FFC93976FFF  001a7000
2022-05-26 06:30:01.25 spid183     * ACEOLEDB                       00007FFC86DB0000  00007FFC86E30FFF  00081000
2022-05-26 06:30:01.25 spid183     * MSVCR90                        0000000074930000  00000000749D2FFF  000a3000
2022-05-26 06:30:01.25 spid183     * mso                            00007FFC784A0000  00007FFC79BDCFFF  0173d000
2022-05-26 06:30:01.25 spid183     * msi                            00007FFC78010000  00007FFC78491FFF  00482000
2022-05-26 06:30:01.25 spid183     * srpapi                         00007FFCA2220000  00007FFCA2249FFF  0002a000
2022-05-26 06:30:01.25 spid183     * ACECORE                        00007FFC83960000  00007FFC83C54FFF  002f5000
2022-05-26 06:30:01.25 spid183     * MSVCP90                        0000000074850000  0000000074922FFF  000d3000
2022-05-26 06:30:01.25 spid183     * ACEWSTR                        00007FFC86CD0000  00007FFC86DA4FFF  000d5000
2022-05-26 06:30:01.25 spid183     * MSORES                         000001D79F2F0000  000001D7A381AFFF  0452b000
2022-05-26 06:30:01.25 spid183     * MSOINTL                        000001DC12AC0000  000001DC12D29FFF  0026a000
2022-05-26 06:30:01.25 spid183     * ACEINTL                        00007FFCA21E0000  00007FFCA2212FFF  00033000
2022-05-26 06:30:01.25 spid183     * msxml6                         00007FFC861C0000  00007FFC86416FFF  00257000
2022-05-26 06:30:01.25 spid183     * odbccp32                       00007FFC8A080000  00007FFC8A0A5FFF  00026000
2022-05-26 06:30:01.25 spid183     * sqlvdi                         00007FFCA23C0000  00007FFCA23FAFFF  0003b000
2022-05-26 06:30:01.25 spid183     *
2022-05-26 06:30:01.25 spid183     *     P1Home: 000001EA00000000:  
2022-05-26 06:30:01.25 spid183     *     P2Home: 00007FFC95D66469:  059647840F58F883  40245C8B48C03200  C483484824748B48  9090909090C35F30  4C90909090909090  415541544157DC8B  
2022-05-26 06:30:01.25 spid183     *     P3Home: 000001EAC1888230:  00007FFC975C9F10  0000000000000000  0000000000000000  000001EAC1888280  000001EAC1888290  0024000600000000  
2022-05-26 06:30:01.25 spid183     *     P4Home: 0000002C825F0930:  000000000000002C  0000000000000000  FFFFFFF76430E090  000001EAC1889FD0  0000000000000000  000001EAC1889CE0  
2022-05-26 06:30:01.25 spid183     *     P5Home: FFFFFFFFFFFFFF00:  
2022-05-26 06:30:01.25 spid183     *     P6Home: 000001E225BB5D00:  0000000000000000  FFFFFFFF00000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000  
2022-05-26 06:30:01.25 spid183     * ContextFlags: 000000000010005F:  
2022-05-26 06:30:01.25 spid183     *      MxCsr: 0000000000001FA8:  
2022-05-26 06:30:01.25 spid183     *      SegCs: 0000000000000033:  
2022-05-26 06:30:01.25 spid183     *      SegDs: 000000000000002B:  
2022-05-26 06:30:01.25 spid183     *      SegEs: 000000000000002B:  
2022-05-26 06:30:01.25 spid183     *      SegFs: 0000000000000053:  
2022-05-26 06:30:01.25 spid183     *      SegGs: 000000000000002B:  
2022-05-26 06:30:01.25 spid183     *      SegSs: 000000000000002B:  
2022-05-26 06:30:01.25 spid183     *     EFlags: 0000000000010206:  
2022-05-26 06:30:01.25 spid183     *        Rax: 000001EAC1889FFC:  
2022-05-26 06:30:01.25 spid183     *        Rcx: 0000000000000072:  
2022-05-26 06:30:01.25 spid183     *        Rdx: 0000000000000072:  
2022-05-26 06:30:01.25 spid183     *        Rbx: 000001EAC1888230:  00007FFC975C9F10  0000000000000000  0000000000000000  000001EAC1888280  000001EAC1888290  0024000600000000  
2022-05-26 06:30:01.25 spid183     *        Rsp: 0000002C825F15D0:  000001EAC1888230  0000002C825F16D0  000001EAC1889FD0  0000000000000000  000001E5DDB48206  000001EA58FA7850  
2022-05-26 06:30:01.25 spid183     *        Rbp: 0000002C825F16D0:  00007FFC97573E08  0000E70000000004  000001DBE1359150  0000000700000010  000001000000000A  0000000000000000  
2022-05-26 06:30:01.25 spid183     *        Rsi: 000001EAC1889FD0:  002E006F00620064  0055005F006E0066  007800610054004B  0074006C0075004D  0069006C00700069  006000C400720065  
2022-05-26 06:30:01.25 spid183     *        Rdi: 000000000000002C:  
2022-05-26 06:30:01.25 spid183     *         R8: 0000000000000000:  
2022-05-26 06:30:01.25 spid183     *         R9: FFFFFFF76430E090:  
2022-05-26 06:30:01.25 spid183     *        R10: 000001EAC1889FD0:  002E006F00620064  0055005F006E0066  007800610054004B  0074006C0075004D  0069006C00700069  006000C400720065  
2022-05-26 06:30:01.25 spid183     *        R11: 0000000000000000:  
2022-05-26 06:30:01.25 spid183     *        R12: 000001EAC1889CE0:  00007FFC975C9BA0  BFF0000000000001  000001EAC1889C40  0000000000000001  000001EAC1889D08  000001EAC1889B80  
2022-05-26 06:30:01.25 spid183     *        R13: 000001EA58FA7850:  00007FFC974A1098  0000009100000001  000001DBE1340060  00000000000002D5  000001EA58FA7BB0  000001DBE1340060  
2022-05-26 06:30:01.25 spid183     *        R14: 000001EAC18882C0:  00007FFC97549C98  0000000000000001  000001DBE1340060  0000000000000000  0000000000000000  0000000000000000  
2022-05-26 06:30:01.25 spid183     *        R15: 0000000000000018:  
2022-05-26 06:30:01.25 spid183     *        Rip: 00007FFC96483D83:  F575007E3C834266  44C03305EBFF0345  0004C8858B48F88B  7889441070894800  000000031C40C718  E8000004B08D8D48  
2022-05-26 06:30:01.25 spid183     * *******************************************************************************
2022-05-26 06:30:01.25 spid183     * -------------------------------------------------------------------------------
2022-05-26 06:30:01.25 spid183     * Short Stack Dump
2022-05-26 06:30:01.27 spid183     00007FFC96483D83 Module(sqllang+0000000000903D83)
2022-05-26 06:30:01.27 spid183     00007FFC96483310 Module(sqllang+0000000000903310)
2022-05-26 06:30:01.27 spid183     00007FFC95D6BF6D Module(sqllang+00000000001EBF6D)
2022-05-26 06:30:01.27 spid183     00007FFC95D8C514 Module(sqllang+000000000020C514)
2022-05-26 06:30:01.27 spid183     00007FFC95D8C32B Module(sqllang+000000000020C32B)
2022-05-26 06:30:01.27 spid183     00007FFC95DA36A2 Module(sqllang+00000000002236A2)
2022-05-26 06:30:01.27 spid183     00007FFC95D8C32B Module(sqllang+000000000020C32B)
2022-05-26 06:30:01.27 spid183     00007FFC95D6C1DD Module(sqllang+00000000001EC1DD)
2022-05-26 06:30:01.27 spid183     00007FFC95D29ADD Module(sqllang+00000000001A9ADD)
2022-05-26 06:30:01.27 spid183     00007FFC95D6BC75 Module(sqllang+00000000001EBC75)
2022-05-26 06:30:01.27 spid183     00007FFC95D6C1DD Module(sqllang+00000000001EC1DD)
2022-05-26 06:30:01.27 spid183     00007FFC95D29ADD Module(sqllang+00000000001A9ADD)
2022-05-26 06:30:01.27 spid183     00007FFC95D6A9AF Module(sqllang+00000000001EA9AF)
2022-05-26 06:30:01.27 spid183     00007FFC95D29ADD Module(sqllang+00000000001A9ADD)
2022-05-26 06:30:01.27 spid183     00007FFC95E09598 Module(sqllang+0000000000289598)
2022-05-26 06:30:01.27 spid183     00007FFC95D29ADD Module(sqllang+00000000001A9ADD)
2022-05-26 06:30:01.27 spid183     00007FFC96490A9B Module(sqllang+0000000000910A9B)
2022-05-26 06:30:01.27 spid183     00007FFC96490945 Module(sqllang+0000000000910945)
2022-05-26 06:30:01.27 spid183     00007FFC964907ED Module(sqllang+00000000009107ED)
2022-05-26 06:30:01.27 spid183     00007FFC95D29BB0 Module(sqllang+00000000001A9BB0)
Ivan Bonanno (31 rep)
May 26, 2022, 09:40 AM • Last activity: Jul 26, 2025, 04:03 AM
2 votes
1 answers
195 views
Access is denied for SQLDumper.exe in MS SQL Server
I want to run SQLDumper.exe with process ID 6392 which is the ID of my Express edition. While running I get this error from the OS > access is denied [![enter image description here][1]][1] I've given full control to the SQL Express account name but still get the error. What access should I grant in...
I want to run SQLDumper.exe with process ID 6392 which is the ID of my Express edition. While running I get this error from the OS > access is denied enter image description here I've given full control to the SQL Express account name but still get the error. What access should I grant in order to make it work properly? Thanks for your time!
igelr (2162 rep)
Aug 9, 2018, 06:13 AM • Last activity: Aug 9, 2018, 06:51 AM
2 votes
0 answers
638 views
How to Clean Sensitive Data from SQL Server Dump Files
**How do I clean a SQL Server dump file of confidential/PII/PHI information so I can prepare it for third party analysis?** What am I looking for in the dump files and are there any automated tools to obfuscate things? I have looked on Microsoft and other sites but the information is focused on how...
**How do I clean a SQL Server dump file of confidential/PII/PHI information so I can prepare it for third party analysis?** What am I looking for in the dump files and are there any automated tools to obfuscate things? I have looked on Microsoft and other sites but the information is focused on how to diagnose SQL dumps rather than what is actually contained within. In the most recent release of SSMS they have the "SQL Server Diagnostics (Preview)" (https://blogs.msdn.microsoft.com/sql_server_team/sql-server-diagnostics-preview/) which offers to "Analyze Dumps - Customers using this extension will be able to debug and self-resolve memory dump issues". I'd like to utilize this new tool but confidentiality is paramount, hence the question.
DBADon (325 rep)
Aug 1, 2017, 06:20 PM
1 votes
1 answers
740 views
SQL Server 2008 Agent keep stopping for unknown reason
My MSSQL 2008 service keep stopping don't know why. I took the habit to just restart the service, but it's getting really annoying. Does anyone has a clue on why it keeps shutting down ? Sql server 2008, logged as local. Here are 4 SQLdump from today. [09:29:36 09/28/16][1] [10:05:42 09/28/16][2] [1...
My MSSQL 2008 service keep stopping don't know why. I took the habit to just restart the service, but it's getting really annoying. Does anyone has a clue on why it keeps shutting down ? Sql server 2008, logged as local. Here are 4 SQLdump from today. 09:29:36 09/28/16 10:05:42 09/28/16 10:32:18 09/28/16 10:46:14 09/28/16 found this in my event viewer : > SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart). Error when I tried to install MSSQL 2008 SP3 (x64) > The version of the instance of SQL Server Shared Component does not match the expected version of the update to SQL Server. The version of the SQL Server product installed is 10.50.1600.1 and the version of SQL Server expected is 10.0.1600.22. SELECT @@VERSION res > Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.2 (Build 9200: )
poudigne (113 rep)
Sep 28, 2016, 02:59 PM • Last activity: Sep 29, 2016, 02:02 PM
Showing page 1 of 4 total questions