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” one can print the current setting SELECT OBJECTPROPERTY(object_id('customer'), 'TableTextInRowLimit') — … Continue reading Using sp_tableoption to change “text in row”