Hello. My production sql server is running Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) on a windows server 2003 standard edition machine.
We have a logon trigger running, and one user was updating all the views, and got a login failed due to trigger execution, and a stack dump in the log due to EXCEPTION_ACCESS_VIOLATION.
I tried copying the crash dump to my workstation and downloaded the debugger, but wasn't able to debug it due to all the other files not being present.
Is there any potential issue with me downloading the debugger to our prod server and running it there during non-prime time?
Or has anyone got any suggestions or information on what could have caused the exception, and next steps?
Thanks very much.