Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

audit sql transaction log

i have ms sql 2008 r2 express. can i use kiwi syslog server for tracking sql transaction log of my database and how? some guide or manual?

thanks

Find more posts tagged with

Accepted answers

All comments

blafleur

I had a similar need where i wanted to create syslog alerts based on certain query results. I had to write my own dll and since 2008R2 and below use .net 2.0 I was pretty limited. I ended up writing a dll that sends the syslog request to a webservice that generated the syslog message to my kiwi server.

kstone

You need a way to read the log and send it to the Kiwi Syslog server. I'm not familiar with SQL logging specifically but for disk based logs I typically use NXlog.

gogi100

i read manual for the nxlog but i can't find guide for tracking sql transaction log

kstone

The first question to answer is "is the SQL transaction log a text log file"? If so NXlog, and others, can read it into a syslog server. From some quick searching it appears it is not an actual log file. It seems to be another, special, database table that is not designed for external uses. I'm not a DBA and have never used SQL Server so this may not be 100% accurate.

The second question is "what information are you trying to report on"? It may be possible to export the data via SQL commands but that's way outside my expertise.

gogi100

the informations that i'm trying to report on: insert. update, delete in database. every changes in tables i need to send at the kiwi syslog server

mukultiwari0101

Looking for the perfect transaction log reader then you can use SQL Server Transaction Log Reader. It helps you to repair the corrupted transaction log file of the server. The software can also repair the corrupted LDF files. Any new user can easily use the SQL server log analyzer because the software has an interactive user interface.