Post reply

Primary keys missed

  • July 8, 2003 at 8:25 am

    #63322

    Hi all! Some strange things happens on my production box (W2000 Server SP3 + SQL7 SE SP4). There are some tables that has been lost its primary keys, i don´t know how and when. Is there any way to find where its happens? Any idea about how could this occurs?

    Regards,

    Tmp

  • July 8, 2003 at 9:24 am

    #464529

    Did you transfer any data recently into your prod from some other server? If yes make sure you check the proper check box. It will ask you drop and re create the objects.

    Shas3

  • July 8, 2003 at 9:41 am

    #464543

    No, the only transfer that is made daily is performed by bcp against several tables, which doesn´t have any relation with the tables with missing keys

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

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