trouble with varchar(max)

[tuzojazz]

Hi guys:

I have this line

declare @v varchar(max)

and I get this error

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'max'.

I'm using sql server 2005 and I have read I must set compatibility level at 90 but when I type this code

EXEC sp_dbcmptlevel 'MyBase', '90';

I get this

Msg 15416, Level 16, State 1, Procedure sp_dbcmptlevel, Line 92
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

Valid values of database compatibility level are 60, 65, 70, or 80.

What can I do?
Thanks!

 

[gmmastros]

Run this:

select @@Version

If this reports Microsoft SQL Server 2000, then you are actually running SQL 2000. Even if the compatibility level of a SQL2005 database is set to something earlier, it will still report the correct version.



-George

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