Post reply

Disabling timestamp column

  • December 23, 2007 at 12:10 pm

    #177801

    Hi everyone,

    Does anyone know, is it possible disable automatic updating of timestamp column on SQL 2000?

  • December 23, 2007 at 5:15 pm

    #762465

    Why? And, pretty sure it's not possible.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 24, 2007 at 12:24 pm

    #762580

    Thnk you on your answer.

    I have one more MySQL database on the client side, and replicating data between MsSQL (server side) and MySql (client side) using my own program based on timestamp field in MSSQL table.

    Now we want to update some very old data on the server side, but we don't want replicate data to client database. But, if we update data on the mssql server we will have new rowversion and program will automaticaly replicate that data to the clients. We cannot easly change replication program, so we looking for some other much easier way.

    Thank you any way you help me a lot. Now I know that I must looking for another solution.

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

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