Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

What do you open a logfile with? Expand / Collapse
Author
Message
Posted Wednesday, August 14, 2013 2:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:06 AM
Points: 5, Visits: 12
I have some errorlogs in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSWL\LOG, I have tried opening them with notepad, wordpad, microsoft word, and various other things. What can I view these errorlogs with? Help!
Post #1484491
Posted Wednesday, August 14, 2013 2:50 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
Notepad or any other text editor. The error log files are plain text.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1484499
Posted Wednesday, August 14, 2013 2:52 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 10:17 AM
Points: 31, Visits: 278
I prefer Notepad++ for reading most logs, actually I prefer it for reading anything.
Post #1484502
Posted Wednesday, August 14, 2013 2:55 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
I usually use UltraEdit for it's ability to automatically reload the file on change.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1484505
Posted Wednesday, August 14, 2013 3:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:06 AM
Points: 5, Visits: 12
I have tried to do an "open with" and it says it cannot open them. Hmmmm...
Post #1484524
Posted Wednesday, August 14, 2013 3:49 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
What file are you trying to open?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1484525
Posted Wednesday, August 14, 2013 3:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:06 AM
Points: 5, Visits: 12
ERRLOG, ERRLOG.1, ERRLOG.2, etc.

The directory is in my original post. This is strange.
Post #1484530
Posted Wednesday, August 14, 2013 4:02 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
I assume you mean ERRORLOG, ERRORLOG.1, etc. They're text files, any text editor or word processor can handle them

Double click the file. Windows will bring up a dialog that says


Select the "Select a program" option. On the dialog that then opens pick Notepad, click OK. Errorlog file opens in notepad.


If you don't want to permanently associate the .1, .2, .3 file 'types' with notepad, then uncheck the option at the bottom of the second dialog before hitting OK

The errorlog file (without extension), will bring up the Open With dialog directly (at least it does in Win7)



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass



  Post Attachments 
Errorlog.jpg (78 views, 48.95 KB)
OpenWith.jpg (78 views, 100.17 KB)
Post #1484535
Posted Wednesday, August 14, 2013 4:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:06 AM
Points: 5, Visits: 12
Thank you! That worked but I do not see why it didn't work the first time... brain damage on my part, very definitely. Problem solved, I appreciate it!
Post #1484545
Posted Thursday, August 15, 2013 2:16 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
GilaMonster (8/14/2013)
I usually use UltraEdit for it's ability to automatically reload the file on change.

Notepad++ can also reload files on change: File Status Auto-Detection
Post #1484632
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse