salim

salim

  • NA
  • 23
  • 0

sql database hosting

Aug 28 2008 2:31 AM
 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)

Answers (1)