Sp_Tableoption for "Large Value Types Out of Row"

• shrikant-279400

  SSCommitted

  Points: 1651

  More actions

  January 16, 2006 at 5:48 am

  #103042

  Hi

     I am working on SQL 2005 Developement Db, As we have some Nvarchar(max) cols,  I had set Sp_Tableoption for "Large Value Types Out of Row" ON for some tables a month back, I need to add some more tables to Database, but before that i want to confirm on which tables I had added this clause.

   I searched Obejectproperty,but they haven't mentioned there ?

   

   

      

  Regards
  Shrikant Kulkarni

• shrikant-279400

  SSCommitted

  Points: 1651

  More actions

  January 17, 2006 at 12:50 am

  #615057

  Hi.

  Select name,type_desc from sys.tables where large_value_types_out_of_row =1

   

  

  Regards
  Shrikant Kulkarni