SQL server logs - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL server logs

Author

Topic

datosiva
Starting Member

18 Posts

Posted - 2011-03-11 : 03:12:27

Dear masters

SQL server logs are not visible through Management studio --> Management -> SQL server Logs
all the 6 archived #x and Current are listed underneath with 0 items in it.

SELECT SERVERPROPERTY ('Errorfilename') shows the below and the folder contains all the approperiate SQL logs.
eg. d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

Then why its not viewable thru management studio?

Please assist.
thanks

shiva :)

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-03-11 : 17:01:10

Are you using the Express edition of the management studio?

datosiva
Starting Member

18 Posts

Posted - 2011-03-15 : 01:29:18

No, using SQL Server 2005 Std Edition.

shiva :)

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-03-15 : 15:38:30

Go to Help | About in SSMS and verify that the client tools are not the Express edition of the client tools. If they are not the express edition, then you need to verify whether or not you have permissions to access the log files.

Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources