May 24, 2006 at 1:36 pm
Hi
Microsoft SQL Server Management Studio Express 9.00.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
I am able to edit SQL Error log by using a text editor
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
But I am not able to view the same SQL Error log by using SQL Server Management Studio (SSMS). When I go Object Explorer / expand management / expand SQL Server logs and I Right-click the current log, I can only REFRESH the error log. I cannot VIEW SQL SERVER LOG. It looks like the current error log is empty (but it is not empy).
Any idea ?
Thank you
Calico
May 29, 2006 at 8:00 am
This was removed by the editor as SPAM
June 6, 2006 at 4:32 am
Have you already had any success? I am facing the same problem, even though the logs are there (of course) and EXEC master..xp_readerrorlog also does exactly what it's supposed to. Only nothing to see in SSMS. Any clues?
June 6, 2006 at 7:07 am
From Holger Tasch : Have you already had any success?
Answer from Calico : NO
Calico
June 6, 2006 at 9:03 am
Has anyone called MS PSS about this issue ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 6, 2006 at 9:06 am
NO
Calico
September 8, 2006 at 4:38 am
I have exactly the same problem with SQL Server Express SP1. Here is information from about box of Management Studio Express:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 built by: (_sqlbld)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2800.1106
Microsoft .NET Framework 2.0.50727.42
Operating System 5.0.2195
September 11, 2006 at 9:59 pm
did someone try running
EXEC master.dbo.xp_readerrorlog 0, 1, NULL, NULL, NULL, NULL, N'desc'
may be some issue with interface??
September 12, 2006 at 2:59 am
xp_readerrorlog works fine. But interface does not.
May be this is side effect of SQL Server Agent absence in Express edition?
I have only Express edition installed...
November 15, 2006 at 11:53 am
I am having the same problem. I just downloaded Management Studio Express today and registered both the Sql Server Express Edition that came with my Visual Studio .Net 2003 and a Sql Server 2000 database. In both cases the Sql Server Logs are listed but when you click on a specific log, 0 Item(s) display and if you right click on the log, only the refresh option is available. I'm going to go look to see if there are any patches available for MSE.
Steve
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply