Re: SQL Express - How do I view SQL Server Log Files
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 28 Sep 2007 22:04:49 +0000 (UTC)
TG (TG@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
It seems the Log File Viewer is not included with SQL Express w/Advanced
Services, or at least I have not found how to view the log files using
anything other than Notepad. I'm having a hard time believing they didn't
include a way for users/dba to view the log files except the hard way.
Indeed, in Mgmt Studio Express you see a list of the logs, but you cannot
view the logs themselves.
Personally, I much prefer to access the SQL Server error log directly
than looking at it through a GUI. The log of a server that has been running
for a long while can be huge, and I don't want to wait for to load.
And a good editor like Textpad will show the log in Courier or some other
fixed fonts, while SSMS displays it in MS Sans Serif, which does not make
things any easier.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: SQL Profiler blocks while replaying in the order they were traced
- Next by Date: Re: Backing Up Mirrored database
- Previous by thread: Re: SQL Express - How do I view SQL Server Log Files
- Next by thread: SQL Profiler blocks while replaying in the order they were traced
- Index(es):
Relevant Pages
|
