Post reply

View host_name in database log

  • July 31, 2009 at 10:58 pm

    #103793

    Please i use redgate to view database logs but it dose not include host name column.

    is there any way or appication i can see the database logs with the hostname included

    Please help ,, thanks

  • August 1, 2009 at 12:02 am

    #1033284

    the workstation name, you can't see in the DB tables unless you store it in the table

    or use this

    select HOST_NAME ( )

    to see thro the application

  • August 1, 2009 at 12:08 am

    #1033286

    thanks for the reply

    how can i use this to see last week database log inculding the workstation (host_name)?

    the profiler shows the host name but i need to view old transaction done last week and the profiler was not on, can i get this information from the log.

    Please say yes

  • August 1, 2009 at 12:47 am

    #1033289

    Hi,

    you have any AuditDb for the applicationDB?

  • August 1, 2009 at 12:56 am

    #1033290

    no i only use redgate to view log

  • August 1, 2009 at 2:10 am

    #1033299

    Are you using SQL Log rescue? If so, I don't think the host name is saved in the transaction log. It's unnecessary for what the transaction log is - a record of all operations done for database consistency and recovery purposes.

    I've read through the raw transaction log a few times, never seen hostname in there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2009 at 2:22 am

    #1033304

    is there a way i can use the profiler to view transactions log file

  • August 1, 2009 at 2:45 am

    #1033308

    No, and even if there was, you still wouldn't be able to get the host name. That information is not in the transaction log.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2009 at 2:47 am

    #1033309

    Bear in mind that the transaction log was not intended as an audit log. It's used for SQL to do transaction rollbacks and to ensure database integrity.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 1, 2009 at 3:01 am

    #1033312

    ok i understood but here is the situation:

    an entry was changed in the database and i need to identify the workstation (host_name) it was made from.

    what can i do?

    Thanks..

  • August 1, 2009 at 3:41 am

    #1033314

    Unless you had a trace running or a trigger on the table that captured that info, as far as I'm aware, you can't.

    You should be able to get the uid and hence the user and/or login name from the transaction log. If you're using individual logins, that will tell you who did it, but not from where.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 11 posts - 1 through 10 (of 10 total)

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