SQLUSA

Microsoft SQL Server 2005 Best Practices

How to use sp_tableoption?

 

Execute the following script in Query Editor to configure XML data storage outside the table. It can also be used to control the storage of small textdata.


USE AdventureWorks;
GO
EXEC sp_tableoption 'Production.Illustration', 'large value types out of row', 1;
GO
-- to reverse it

EXEC sp_tableoption 'Production.Illustration', 'large value types out of row', 0;
GO

 

SQLUSA - The Best SQL Server 2005 Training in the World
 
 
SQLUSA.com Home Page