Wednesday, July 22, 2015

How to Enable or Disable Trigger in Sql Server 2008/2008R2 



USE Database
GO
DISABLE TRIGGER Trigger_Name ON Table_Name;
GO
Posted by at

2 comments:

  1. UnknownDecember 9, 2017 at 8:50 PM

    EXEC sp_resetstatus [pest_pesto_pmcs];
    ALTER DATABASE [pest_pesto_pmcs] SET EMERGENCY
    DBCC checkdb([pest_pesto_pmcs])
    ALTER DATABASE [pest_pesto_pmcs] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    DBCC CheckDB ([pest_pesto_pmcs], REPAIR_ALLOW_DATA_LOSS)
    ALTER DATABASE [pest_pesto_pmcs] SET MULTI_USER

    ReplyDelete
  2. UnknownDecember 9, 2017 at 8:51 PM

    How to Repair Suspect database--

    EXEC sp_resetstatus [pest_pesto_pmcs];
    ALTER DATABASE [pest_pesto_pmcs] SET EMERGENCY
    DBCC checkdb([pest_pesto_pmcs])
    ALTER DATABASE [pest_pesto_pmcs] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    DBCC CheckDB ([pest_pesto_pmcs], REPAIR_ALLOW_DATA_LOSS)
    ALTER DATABASE [pest_pesto_pmcs] SET MULTI_USER

    ReplyDelete

Subscribe to: Post Comments (Atom)