ALTER COLUMN failing

ALTER TABLE Gen_Demo ADD email4 VARCHAR(50)
go
ALTER TABLE Gen_Demo ALTER COLUMN email4 VARCHAR(101)
go
when executed in Query Analyzer -
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'COLUMN'.
however this same code works on a friends SQL Server
Any ideas ?
Are you using SQL Server 7.0, or 2000 in compatibility = 70?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"glose" <anonymous@.discussions.microsoft.com> wrote in message
news:79729B16-964E-4EB3-AE62-B6BD6699B87F@.microsoft.com...
> ALTER TABLE Gen_Demo ADD email4 VARCHAR(50)
> go
> ALTER TABLE Gen_Demo ALTER COLUMN email4 VARCHAR(101)
> go
> when executed in Query Analyzer -
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'COLUMN'.
> however this same code works on a friends SQL Server
> Any ideas ?
|||oops - thanks -that was it the compatability was set to 65 for some reason.