Post reply

what is net change method

  • September 25, 2009 at 4:00 am

    #139009

    Hi friends,

    I heard from my colleague that they have stored procedures return in sql server 2000. They want to modify those stored procedures in sql 2008 using NET CHANGE METHOD.

    Finally they want to test new SP and old SP parallel and check net change method is working well.

    thanks in advance

  • October 2, 2009 at 12:39 am

    #1060796

    This is not a standard phrase. I'm *guessing* that the sprocs would return all the rows affected by any actions it took. This is often easier said than done.. I'd ask your colleagues some more questions..

    CEWII

  • October 2, 2009 at 10:01 am

    #1061040

    I'm thinkingh they're talking about the new SQL 2008 Change Data Capture functionality. I'm very sketchy on how it works in SS2008, so your best bet is to pop into BOL to read up on it.

    There are some provided system functions for identifying the "net data changes", in a set of data headed to your BI system.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • October 2, 2009 at 2:45 pm

    #1061194

    i dont even see a question here..?

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

  • October 2, 2009 at 2:52 pm

    #1061200

    torpkev (10/2/2009)

    i dont even see a question here..?

    Title of the thread: what is net change method

  • October 2, 2009 at 2:56 pm

    #1061204

    ahh i see now.. doh

    --------------------------

    I long for a job where my databases dont have any pesky users accessing them 🙂

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

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