QUESTION POSED ON: 11 September 2007
I have tried to use this data type feature with SQL Server 2005 Express Edition as well Enterprise Edition:
CREATE TABLE largeValues (
lVarchar VARCHAR (MAX),
lnVarchar NVARCHAR (MAX),
lVarbinary VARBINARY (MAX)
)
But it is not working. It is giving me the following error:
Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'MAX'.
Which edition will it work in? Can we make some configurations for this feature to be successful, or is it only available for the licensed version of SQL Server 2005.
|
