Forum Discussion

Martin_Sachers's avatar
Martin_Sachers
Copper Contributor
Aug 04, 2022
Solved

Error 3727

Hi there, I try to delete a foreign key with " ALTER TABLE [dbo].[Projektplanung] DROP CONSTRAINT [Projektplanung$tblLookupCountriesProjektplanung] GO " But I have to cancel it and get Err 3737...
  • olafhelper's avatar
    olafhelper
    Aug 04, 2022

    Martin_Sachers , next time please post the complete error message, not only the number.

    select *
from sys.messages
where message_id = 3727

    > Could not drop constraint. See previous errors.

    And what was the previous error?

     

    Olaf

olafhelper's avatar
olafhelper
Bronze Contributor
Aug 04, 2022

Martin_Sachers , next time please post the complete error message, not only the number.

select *
from sys.messages
where message_id = 3727

> Could not drop constraint. See previous errors.

And what was the previous error?

 

Olaf

Martin_Sachers's avatar
Martin_Sachers
Copper Contributor
Aug 04, 2022

olafhelper There were no previous errors. It just did nothing visibly.

The problem is solved: There are 4 foreign keys which connect to the table. I tried the whole story an hour later and it worked again. Conclusio: The table was locked. The problem is that it didn´t show at all.

 

BR

Martin

  • Ronen_Ariely's avatar
    Ronen_Ariely
    MVP
    Aug 06, 2022

    Hi Martin_Sachers

    For the sake of the next time.


    > There were no previous errors.

     

    You can get the previous error and all the information which come in the errors from the SQL Server error log file, as explain the this doc.

     

    > Conclusio: The table was locked. The problem is that it didn´t show at all.

     

    Next time you can check locks using sp_lock or sys.dm_tran_locks.

    I am not sure that your conclusion are correct without more info

     

    > The problem is solved

     

    Glad to hear 🙂 have a great day

Resources