| 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 |
|