Thanks for the reply! now, life has taught me not to forget to make a backup!

Error Msg 7929, Level 16, State 1, Line 1

Check statement aborted. Database contains deferred transactions.