Solved

diff in file format of trace and errorlog

Posted on 2011-09-08
5
351 Views
Last Modified: 2012-06-21
is it possible to convert the format of errorlog file into a trace file format?

the errorlog sits in C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
0
Comment
Question by:25112
  • 3
5 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36507739
Why do you want the readable error log file in trace format?
0
 
LVL 5

Author Comment

by:25112
ID: 36507779
so i can query it with selects.. or see how many rows are there etc

both are rows+columns format.. so was hoping to use like trace file
0
 
LVL 5

Author Comment

by:25112
ID: 36507781
just checking that possibility
0
 
LVL 5

Accepted Solution

by:
VENKAT KOKULLA earned 500 total points
ID: 36527688
Please go through below site might it will helpout:

http://www.sqlmgmt.com/ProductDetail.aspx?Id=106
0
 
LVL 5

Author Comment

by:25112
ID: 36537152
VENKAT1242, I am interested in the errorlog file first- if it can be converted into trace.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Backup 24 70
Complex SQL 10 34
How to select Week Start and Week End dates 5 27
Contained Database Collations 6 20
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now