no items in sql server error logs

[niall5098]

Hi All,

I have been having an issue with my errorlogs, when i expand the sql server error logs there are no items on display, there are in the correct folder and startup parameter is pointing to the file, however when i right click on sql server agent and select display error log i get the following error:

error 2812: could not find stored procedure 'master.dbo.xp_regread'.

Any help would be appreciated

 

[ptheriault]

Please run SELECT @@VERSION and post the results here.


- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

For SQL 2000
First make sure that you have the xpstar.dll in the binn folder of your sql server install root. If you don't you can download it from here.

http://www.dlldump.com/download-dll-files_new.php/dllfiles/X/XPSTAR.DLL/1998.11.138/download.html

If you do the re-add it witht he following.

[COLOR=blue]EXEC[/color] sp_addextendedproc xp_regread, [COLOR=red]'xpstar.dll'[/color]

For 2005 follow the same steps but you are looking for xpstar90.dll instead.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[niall5098]

Hi Paul,


First of all, thanks for your reply.

secondly i checked the binn folder and the file is present

 

[ptheriault]

I would run the script to re-add it. Also, what version are you at?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[niall5098]

i will run the re-attach in a moment, version is:


Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

 

[ptheriault]

You version is SP3a. I would upgrade to SP4. It may also correct your problem.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[niall5098]

Hi,

Have ran the attach sql, seems to have the trick, however the error logs are still not showing when expanded, have recycled the log and done a refresh, to no avail

 

[ptheriault]

Does EM hand when you try to open the log? Have you tried to open the log in text pad?
You can find the logs in the log folder from your sql install root.

?:\program fils\Microsoft SQL Server\MSSQL\LOGS

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[niall5098]

yeh the logs are there and the startup parameter is pointing to the correct folder, hence my confusion, i have done a stop start on the sql server agent, that had no effect either

 

[ptheriault]

Are there any records in the logs?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[niall5098]

Theres is yes

 

[ptheriault]

Is this a production SQL Server? I would apply sp4 if it is supported by the application.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[niall5098]

It is a production server, i will look into applying sp 4 and will let you know the results