i have made a database on sql express Version is 9.0.3042 and when i am hosting this data base to server which version is 8.0.2039 ther it show error
// this code 4 create table--------------
GO
CREATE TABLE [dbo].[vendor](
[vid] [bigint] IDENTITY(1,1) NOT NULL,
[vname] [nvarchar](50) NULL,
[mobno] [nvarchar](50) NULL,
[email] [nvarchar](50) NULL,
[address] [nvarchar](max) NULL,
[city] [nvarchar](50) NULL,
[zip] [nvarchar](50) NULL,
[country] [nvarchar](50) NULL,
[telno] [nvarchar](20) NULL,
[description] [nvarchar](max) NULL,
CONSTRAINT [PK_vender] PRIMARY KEY CLUSTERED
(
[vid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
//---------
Error is------------------------
Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near 'max'.
----------------
plez help me and thank 4 appropriate ans.
(if any controversy b/w these version then how it will solve)