getting syntax error when trying to use nvarchar(max) 1

[gtob5]

Using SQL Server 2005 Std Edition on two different systems
on one the following code works and on the other I get a syntax error near 'max'.

create table tbla (
id int not null,
abx nvarchar(max) null)

if I substitute 255 for max, it works.

all the settings seem to be identical.
any ideas?

 

[gmmastros]

Before you go crazy.... can you make sure it's a SQL 2005 instance? It's super easy to tell. Run this...

Select @@Version

If the output begins with.... Microsoft SQL Server 2000, then there is nothing you can do to use the nvarchar(max).

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Obvious answer - you're not using SQL Server 2005 on the other server.

Try

SELECT
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel