Post reply

Customized Log Report requirement

  • May 12, 2012 at 9:52 am

    #274061

    Greetings to all!

    I am new to Database Administration and have to manage MS SQL 2008 Server of a customer. Customer's requirement is as below:

    There are couple of applications which affect the following tables during the day:

    1) Forecast_temp

    2) Forecast

    3) Forecast_Current

    4) Forecast_Current_Temp

    5) Forecast_mob

    6) Forecast_Mob_Today

    7) Forecast_Sunriseset

    Need a log file with following details on daily basis

    1) Total number of records inserted, updated or deleted with table names and time of the transaction.

    I have to get back to the customer on a very short time frame. Any help / advise / guidance will really be appreciated.

    Best Regards,

  • May 12, 2012 at 4:26 pm

    #1486804

    Only way i see getting those totals would be by using Change data cature on those tables in question.

    Then you can query the cdc schema rltables for the counts

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 12, 2012 at 11:29 pm

    #1486835

    Thanks indeed for your prompt guidance.

    I have got a link (see below) from one of my friends which appears to be very helpful in setting up CDC in SQL. I am yet to follow the instructions mentioned in the article. Will keep posted on further results shortly.

    http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/

    (If clicking the link doesn't work, copy & paste the full URL in your browser)

    Cheers!

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

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