Red Gate forums :: View topic - properblem reading error log after installation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

properblem reading error log after installation

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
laertes



Joined: 02 May 2012
Posts: 2

PostPosted: Wed May 02, 2012 9:41 am    Post subject: properblem reading error log after installation Reply with quote

Hi,
I installed sql Mon 3.0 this weeken and now i am seeing a lot of the following error:

Error: 18002, Severity: 20, State: 1.
Exception happened when running extended stored procedure 'xp_readerrorlog' in the library 'xpstar90.dll'. SQL Server is terminating process 94. Exception type: Win32 exception; Exception code: 0xc0000005.

Is this an error introduced by sql mon 3 or is it something I need to adress?

regards,
/Lars
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Wed May 02, 2012 11:16 am    Post subject: Reply with quote

Hi Lars,

C0000005 is an "access violation", meaning the extended stored procedure is trying to read or write memory that is outside the address space of SQL Server. It means that the SQL Server installation has come unglued. You can try reinstalling or removing/readding the extended stored procedure.
Back to top
View user's profile Send private message
laertes



Joined: 02 May 2012
Posts: 2

PostPosted: Wed May 02, 2012 11:19 am    Post subject: Reply with quote

Hi, thanks for the reply.

Could you tell me which is the easiest way to reinstall the extended SP?

regards,
/Lars
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Wed May 02, 2012 12:01 pm    Post subject: Reply with quote

SQL Server has a procedure "sp_addextendedproc" that you can use. So for starters you can sp_dropextendedproc and then sp_addextendedproc-it back in. As it's a system procedure, you may need to repair the installation though.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group