Post reply

Missing Relationships

  • October 25, 2015 at 6:17 am

    #322087

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

  • October 25, 2015 at 6:53 am

    #1835398

    You can put an audit to track when the DDL is fired. Any ORM accessing the tables?

    Jayanth Kurup[/url]

  • October 25, 2015 at 9:18 am

    #1835408

    Ratheesh.K.Nair (10/25/2015)

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

    What do you mean here? Are you talking about FK's being removed or are you talking about the data within a table actually being removed?

    --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)

  • October 25, 2015 at 9:19 am

    #1835409

    Ratheesh.K.Nair (10/25/2015)

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

    Quick question, have you checked the default trace?

    😎

  • October 25, 2015 at 10:14 pm

    #1835442

    Jayanth_Kurup (10/25/2015)

    You can put an audit to track when the DDL is fired. Any ORM accessing the tables?

    Thanks Jayanth , Will put an audit . Yes developers are using ORM.

  • October 25, 2015 at 10:14 pm

    #1835443

    Jeff Moden (10/25/2015)

    Ratheesh.K.Nair (10/25/2015)

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

    What do you mean here? Are you talking about FK's being removed or are you talking about the data within a table actually being removed?

    Thanks Jeff, FK's been removed.

  • October 25, 2015 at 10:17 pm

    #1835444

    Eirikur Eiriksson (10/25/2015)

    Ratheesh.K.Nair (10/25/2015)

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

    Quick question, have you checked the default trace?

    😎

    Thanks Eiriksson, This seems to have happened 3 months back didnt find that old trace to back track.

  • October 25, 2015 at 10:30 pm

    #1835445

    Ratheesh.K.Nair (10/25/2015)

    Jeff Moden (10/25/2015)

    Ratheesh.K.Nair (10/25/2015)

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

    What do you mean here? Are you talking about FK's being removed or are you talking about the data within a table actually being removed?

    Thanks Jeff, FK's been removed.

    FK's are not automatically removed except when a table is dropped. If no one is dropping tables, then someone is dropping the FKs intentionally or by job. You need to monitor the default trace and possibly setup a system trigger to log who, what, where, and when. Then, introduce them to some very high velocity pork chops.

    --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)

  • October 25, 2015 at 10:56 pm

    #1835447

    Jeff Moden (10/25/2015)

    Ratheesh.K.Nair (10/25/2015)

    Jeff Moden (10/25/2015)

    Ratheesh.K.Nair (10/25/2015)

    Hi Experts,

    We are observing very strange scenario in which some relationships are getting removed from tables. We havent deleted any tables? Can anyone help me understand or any way to find it?

    TIA

    What do you mean here? Are you talking about FK's being removed or are you talking about the data within a table actually being removed?

    Thanks Jeff, FK's been removed.

    FK's are not automatically removed except when a table is dropped. If no one is dropping tables, then someone is dropping the FKs intentionally or by job. You need to monitor the default trace and possibly setup a system trigger to log who, what, where, and when. Then, introduce them to some very high velocity pork chops.

    Jeff :-P.. Will enable audit to check for DDL changes.

  • October 26, 2015 at 12:45 pm

    #1835588

    Jeff Moden (10/25/2015)

    ... Then, introduce them to some very high velocity pork chops.

    As it happens, I was eating a brisket and sausage sandwich when I read this. Fortunately I knew your penchant for fast-moving porcine portions and didn't spray it all over my setup. 😀

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • October 26, 2015 at 7:41 pm

    #1835629

    Wayne West (10/26/2015)

    Jeff Moden (10/25/2015)

    ... Then, introduce them to some very high velocity pork chops.

    As it happens, I was eating a brisket and sausage sandwich when I read this. Fortunately I knew your penchant for fast-moving porcine portions and didn't spray it all over my setup. 😀

    You've seen my updated pork chop launcher, haven't you? Went whole hawg on it. 😀

    --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)

  • October 27, 2015 at 9:24 am

    #1835824

    Personally I think that since you're doing air-to-ground attack, the plane should be an A-10 Warthog. 🙂

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 12 posts - 1 through 11 (of 11 total)

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