Post reply

Reading the Log File

  • December 8, 2003 at 6:28 pm

    #64706

    Hi

    I was wondering if there is any way of getting the user id of a transaction in the

    transaction log. I have used dbcc log (<<database name>>) but it does not provide

    me with anything useful.

    I know there is a product available lumigent log explorer but it's asking price is insane.

    Does anyone know of a cheaper product etc?

    Thanks

  • December 8, 2003 at 8:43 pm

    #485230

    I think lumigent know how many competitors they've got... hence the insane price.

    You may be able to get something useful out of fn_dblog. For starters try:

    select [server uid], uid, * from ::fn_dblog(null,null)

    where operation like '%BEGIN_XACT%'

    order by [transaction id] desc

    Cheers,

    - Mark

    Edited by - mccork on 12/08/2003 8:43:51 PM


    Cheers,
    - Mark

  • December 8, 2003 at 11:49 pm

    #485243

    Hi Mark,

    I check out BOL for "fn_dblog" but did not find anything relating it. Where can I find the help regarding this function?

    Sachin

    🙂


    Regards,
    Sachin Dedhia

  • December 9, 2003 at 12:08 am

    #485245

    Sachin,

    Hardly anywhere I'm afraid.

    Just a search of newsgroups to find out how to call it. I don't even know what can be substituted for the NULL arguments, but I hear they could be LSNs (probably to limit the results set.

    If you find out any more about it I'd be delighted.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • December 9, 2003 at 12:23 am

    #485248

    Something is better than nothing

    Thanks Mark. It will be my pleasure to keep you posted in case I come across anything regardig this.

    Sachin

    🙂


    Regards,
    Sachin Dedhia

  • December 9, 2003 at 12:39 am

    #485249

    You can take a look at this...

    http://www.novicksoftware.com/UDFofWeek/Vol1/T-SQL-UDF-Volume-1-Number-27-fn_dblog.htm

    Also this function is undocumented, may not be reliable and should be used at

    your own risk

    HTH

    Sachin


    Regards,
    Sachin Dedhia

  • December 9, 2003 at 2:02 am

    #485254

    Getting back to the original question I think http://www.lockwoodtech.com has a similar product.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

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