large value types out of row
-
I am trying to create a table containing a varbinary(max) data type. The max key-word is specified in BOL but it also indicates I should done a sp_tableoption with one of the parameter values "large value types out of row". This is not working as the value does not exists. I will appreciate some guidence on how to enable this data type.
-
I am trying to create a table containing a varbinary(max) data type. The max key-word is specified in BOL but it also indicates I should done a sp_tableoption with one of the parameter values "large value types out of row". This is not working as the value does not exists. I will appreciate some guidence on how to enable this data type.
varbinary(max)is new in SQL Server 2005. If your server is older (SQL Server 7.0 or 2000) the nearest equivalent is theimagedata type. To check what version the server is, run the querySELECT @@VERSION. SQL Server 2000 is version 8.0, SQL Server 2005 is 9.0.Stability. What an interesting concept. -- Chris Maunder