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"... Continue Reading →


Blog at

Up ↑