May 10, 2010 at 12:17 pm
Plz let me know what cause it will come alert
A user request from the session with SPID 285 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
Sourcespid285
Message
Using 'dbghelp.dll' version '4.0.5'
Message
SqlDumpExceptionHandler: Process 285 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Sourcespid285
Message
* BEGIN STACK DUMP:
Message
* Exception Address = 0000000077EDB7B7 Module(ntdll+000000000001B7B7)
Message
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
Message
* Access Violation occurred reading address FFFFFFFFFFFFFFFF
Message
* Input Buffer 60 bytes -
Message
* PRC_LOAD_ESP_TO_STG
Message
A user request from the session with SPID 285 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
May 10, 2010 at 12:24 pm
What is the current version/SP/CU of your sql server?
Try installing the latest SP (test test test first) and /or CU
May 10, 2010 at 12:33 pm
How can i check plz let me know?
May 10, 2010 at 1:52 pm
Run this snippet and let us know the results.
Select SERVERPROPERTY('Edition') as Edition
,SERVERPROPERTY('ProductVersion') as ProdVersion
,SERVERPROPERTY('ProductLevel') as ProdLevel
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 10, 2010 at 2:10 pm
Enterprise Edition (64-bit)9.00.3282.00SP2
this is o/p i have ran the above query
May 10, 2010 at 3:12 pm
Its a long shot but try installing SP3
Build list here
http://www.sqlservercentral.com/articles/Administration/2960/
May 10, 2010 at 4:59 pm
sql_lock (5/10/2010)
Its a long shot but try installing SP3Build list here
http://www.sqlservercentral.com/articles/Administration/2960/
I second that suggestion.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply