Post reply

Disabling Constaraints

  • August 9, 2005 at 5:21 am

    #87088

    Big question:

    It is harmless disable constraints in a production SQL server and enable them again after a job is finished. (Insert, update are continuosly made by application running against the DB).

    The job is: deleting on tables (table correlated but for which I don' want to keep correlation  - in some table some record must be kept and reused).

    Thank

  • August 9, 2005 at 5:54 am

    #580653

    Not knowing any details of your system, but.. No, it's not "harmless" to disable a constraint on a production table, especially if activity is still going on.

    On the other hand, if the disabled constraint only deals with something that is going to be taken away, and it doesn't have anything to do with things that are to be left, then it may be "harmless" anyway..

    It depends...

    /Kenneth

  • August 9, 2005 at 1:42 pm

    #580843

    Thank

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

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