Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

In the SQL Server Management Studio in Management I can view the SQL Server Logs.

I "inherited" a server where this Log is always empty. I'd guess my predecessor somehow disabled the SQL Server Log.

How do I enable this Log again?

share|improve this question
I'm not following you. What version/edition of SQL are you working with? Are you referring to the SQL Server Configuration Manager? Are you referring to Shared Memory, Named Pipes, TCP/IP, and VIA? –  joeqwerty Jun 22 '11 at 11:35
Ah, sorry, I refer to SQL Server Management Studio (at least that's the name in the german edition). I wrote "tools" above. It's SQL Server 2005, but I guess the source would be the same for 2008. –  Sam Jun 22 '11 at 13:10
Here, this software I refer to: en.wikipedia.org/wiki/SQL_Server_Management_Studio - it is contained in the SQL Server package as optional install. –  Sam Jun 22 '11 at 13:13
Here's a screen cap of mine, where are you having the problem? i1195.photobucket.com/albums/aa384/RateControl/SSMS.png –  RateControl Jun 22 '11 at 13:21
Ah, ok, the menu item is called "management > SQL Server logs" in the english version (I guessed my translation wrong). Thanks!! –  Sam Jun 22 '11 at 13:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.