Post reply

Where and how can I see log records for updates, insert, delete using Enterprise Manager?

  • February 4, 2005 at 10:37 pm

    #162480

    Where and how can I see log records for updates, insert, delete using Enterprise Manager?

    SQL server 2000 has log records for every change in the db. How can I see these records in a tabular form?

    Is there anyway to use the logrecords of updates, insert, and delete to periodically send out updates to linked servers?

  • February 4, 2005 at 10:38 pm

    #540802

    I don't think there is a way to see them in Enterprise Manager.  The only way I have heard is with third party tools, like Lumigent Log Explorer.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • February 7, 2005 at 6:34 am

    #540913

    Yes you can see these logs but not in enterprise manager. I suggest you to use sql profiler in that case. Or if you have transaction logs then you could use third-party tool log explorer

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

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