Post reply

Log File View

  • May 16, 2008 at 12:13 am

    #380577

    Is any one know the method of viewing .ldf file (Log File) . I have a database . I want to see all the DML command given to that database .

    Regards,

    REJI P R

  • May 16, 2008 at 2:04 am

    #816298

    Hi,

    You can see the log fil by using the function.

    Use database_name

    go

    select * from fn_dblog(null,null)

    I have provided the code as is. Please take special care and attention before running the command. You can take the database backup before running the command.

    Thanks and regards,

    Veeresh.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply