SP to enable, disable or list all Triggers in  DB

SQL 7.0 and 2000 modified version of Rodrigo Acosta (racosta) Argentina Script that enable,disable or list all the Triggers in the given database. If enable or disable are specified, finds all the triggers of all the tables and enable or disable them, After that, it list all the triggers with it´s current state. If List […]

2004-03-19

150 reads

Blogs

Investigating Azure Databricks

By

At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure...

Understanding Columnstore Indexes in SQL Server Part 3

By

My last two blogs were on understanding columnstore and creating columnstore indexes. In this...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Convert smallint to Date

By PJ_SQL

Hello! I have column in SQL 2012 DB of datatype smallint. Could you please...

Managed Instance Error Creating Recurring Schedule - BUG???

By DBADave

When we try to create a SQL Server Agent job schedule that has a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers