Riddhi Valecha

Riddhi Valecha

  • 443
  • 3.3k
  • 413.1k

Database Logs

Mar 22 2016 9:22 AM
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 .....

Answers (2)