Database Logs

Riddhi Valecha

Dear All...

I have a requirement for Database Logs -

There are many databases used - SQL Server , Oracle, Microsoft Access, etc.

Now, I want to make a program to get the Database Logs.

I know one command - select * from sys.fn_dblog(NULL,NULL)

But, I want other output along with the output of this query -
Computer name - The machine name from which the command was executed.
Command Name - Select / Insert / Update

I have to make this Logs in asp.net web application.

How do I proceed ?

I just have server (10.11.12.12) and username and password .....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha10y ago
Hi..

I want the output as follows / I need the following data -
Computer Host Name,
Computer IP Address,
Command - Select / Insert / update/etc,
Date and time
---------
I have the database server credentials - server - 1.1.1.1, user , pass...
and in asp.net c#.
----
Along with - the data on "Activity Monitor" tab in database

Reference - http://www.aspdotnet-suresh.com/2012/12/close-kill-all-active-database.html

Please help.....

I need to develop this logic in asp.net c# - how do I go about it ?
0
Nishant Mittal10y ago
Hey Riddhi,

Hope this will help u

dbcc log('master',3) - This will provide lot of information to us like object name, database name, transaction details like transaction start time /end time/transaction id etc..,
0