Using sp_tableoption to change “text in row”

sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text, ntext, or image columns, pinning a table, table lock on bulk insert. Example: Enables the 'text in row' option on customers table inline limit to 1000 EXEC sp_tableoption 'customers', 'text in row', '1000' Using “OBJECTPROPERTY”…

How to list triggers on a database in SQLServer?

Using the following SQL statement, it will list triggers on database. It also prints trigger name, table the trigger is on, is it a insert, update and delete triggering event, after and instead of trigger, if the trigger is enabled or disabled SELECT trigger_name = name , trigger_owner = USER_NAME(uid) , table_name = OBJECT_NAME(parent_obj) ,…