Additional Articles

Query to Display Trigger Status

Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful […]

5 (1)


1,037 reads


Basic OFFSET–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Calgary Data User Group with Deborah Melkin and Andy Yun


Next week on Wednesday is the Calgary Data User Group’s second event for 2021,...

Daily Coping 21 Apr 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs


Enabling/Configuring Read only routing

By ALearningDBA

I have 2 servers which are part of AG. DB1(Primary) and DB2(Secondary). It has...

Unable to uninstall Sql Server 2019 in my Laptop

By vijayarajanse

Hello, I have installed Sql Server 2019 more than 6 months before and forgot...

Implementing TLS In sql server 2012

By arvind.patil 98284

Hi Experts, In my project we have 2 servers Webserver and one is database...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers