ALTER TABLE SQL7

I used this command on SQL2K to change the length of a column from 150 to
200
ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
I've tried all vesions and perversions of it on SQL7 but keep gettign the
error that there is something wrong around COLUMN
David A. BeckDavid,
Please include the text of the message that you are getting.
Russell Fields
"David A. Beck" <davidb@.beckb.com> wrote in message
news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> I used this command on SQL2K to change the length of a column from 150 to
> 200
> ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> I've tried all vesions and perversions of it on SQL7 but keep gettign the
> error that there is something wrong around COLUMN
> David A. Beck
>|||Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'COLUMN'.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OwHAJic6DHA.696@.tk2msftngp13.phx.gbl...
> David,
> Please include the text of the message that you are getting.
> Russell Fields
> "David A. Beck" <davidb@.beckb.com> wrote in message
> news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> > I used this command on SQL2K to change the length of a column from 150
to
> > 200
> > ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> > I've tried all vesions and perversions of it on SQL7 but keep gettign
the
> > error that there is something wrong around COLUMN
> >
> > David A. Beck
> >
> >
>|||Is the database set to 6.5 compability?
"David A. Beck" <davidb@.beckb.com> wrote in message
news:%23lTlDlc6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'COLUMN'.
>
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OwHAJic6DHA.696@.tk2msftngp13.phx.gbl...
> > David,
> >
> > Please include the text of the message that you are getting.
> >
> > Russell Fields
> > "David A. Beck" <davidb@.beckb.com> wrote in message
> > news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> > > I used this command on SQL2K to change the length of a column from 150
> to
> > > 200
> > > ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> > > I've tried all vesions and perversions of it on SQL7 but keep gettign
> the
> > > error that there is something wrong around COLUMN
> > >
> > > David A. Beck
> > >
> > >
> >
> >
>|||Yes it is.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:uUJU%23sc6DHA.2908@.tk2msftngp13.phx.gbl...
> Is the database set to 6.5 compability?
> "David A. Beck" <davidb@.beckb.com> wrote in message
> news:%23lTlDlc6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > Server: Msg 170, Level 15, State 1, Line 1
> > Line 1: Incorrect syntax near 'COLUMN'.
> >
> >
> > "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> > news:OwHAJic6DHA.696@.tk2msftngp13.phx.gbl...
> > > David,
> > >
> > > Please include the text of the message that you are getting.
> > >
> > > Russell Fields
> > > "David A. Beck" <davidb@.beckb.com> wrote in message
> > > news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> > > > I used this command on SQL2K to change the length of a column from
150
> > to
> > > > 200
> > > > ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> > > > I've tried all vesions and perversions of it on SQL7 but keep
gettign
> > the
> > > > error that there is something wrong around COLUMN
> > > >
> > > > David A. Beck
> > > >
> > > >
> > >
> > >
> >
> >
>|||That's the problem. ALTER support was introduced with v7.
"David A. Beck" <davidb@.beckb.com> wrote in message
news:umAJ7yc6DHA.2628@.TK2MSFTNGP10.phx.gbl...
> Yes it is.
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:uUJU%23sc6DHA.2908@.tk2msftngp13.phx.gbl...
> > Is the database set to 6.5 compability?
> >
> > "David A. Beck" <davidb@.beckb.com> wrote in message
> > news:%23lTlDlc6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > > Server: Msg 170, Level 15, State 1, Line 1
> > > Line 1: Incorrect syntax near 'COLUMN'.
> > >
> > >
> > > "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> > > news:OwHAJic6DHA.696@.tk2msftngp13.phx.gbl...
> > > > David,
> > > >
> > > > Please include the text of the message that you are getting.
> > > >
> > > > Russell Fields
> > > > "David A. Beck" <davidb@.beckb.com> wrote in message
> > > > news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> > > > > I used this command on SQL2K to change the length of a column from
> 150
> > > to
> > > > > 200
> > > > > ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> > > > > I've tried all vesions and perversions of it on SQL7 but keep
> gettign
> > > the
> > > > > error that there is something wrong around COLUMN
> > > > >
> > > > > David A. Beck
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Scott, thanks. The light went on when I read your question. I did change it
and it works. Thanks so much.
David A. Beck
"Scott Morris" <bogus@.bogus.com> wrote in message
news:epMcOFd6DHA.1752@.tk2msftngp13.phx.gbl...
> That's the problem. ALTER support was introduced with v7.
> "David A. Beck" <davidb@.beckb.com> wrote in message
> news:umAJ7yc6DHA.2628@.TK2MSFTNGP10.phx.gbl...
> > Yes it is.
> >
> > "Scott Morris" <bogus@.bogus.com> wrote in message
> > news:uUJU%23sc6DHA.2908@.tk2msftngp13.phx.gbl...
> > > Is the database set to 6.5 compability?
> > >
> > > "David A. Beck" <davidb@.beckb.com> wrote in message
> > > news:%23lTlDlc6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > > > Server: Msg 170, Level 15, State 1, Line 1
> > > > Line 1: Incorrect syntax near 'COLUMN'.
> > > >
> > > >
> > > > "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> > > > news:OwHAJic6DHA.696@.tk2msftngp13.phx.gbl...
> > > > > David,
> > > > >
> > > > > Please include the text of the message that you are getting.
> > > > >
> > > > > Russell Fields
> > > > > "David A. Beck" <davidb@.beckb.com> wrote in message
> > > > > news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> > > > > > I used this command on SQL2K to change the length of a column
from
> > 150
> > > > to
> > > > > > 200
> > > > > > ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> > > > > > I've tried all vesions and perversions of it on SQL7 but keep
> > gettign
> > > > the
> > > > > > error that there is something wrong around COLUMN
> > > > > >
> > > > > > David A. Beck
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||what errors do you get?
"David A. Beck" <davidb@.beckb.com> wrote in message
news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> I used this command on SQL2K to change the length of a column from 150 to
> 200
> ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> I've tried all vesions and perversions of it on SQL7 but keep gettign the
> error that there is something wrong around COLUMN
> David A. Beck
>|||Richard:
Please read further up the string. I already answered that. The problem was
that the database was set to 6.5 compatability. Thanks.
"Richard Ding" <dingr@.cleanharbors.com> wrote in message
news:uzq1qmm6DHA.2720@.TK2MSFTNGP09.phx.gbl...
> what errors do you get?
> "David A. Beck" <davidb@.beckb.com> wrote in message
> news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
> > I used this command on SQL2K to change the length of a column from 150
to
> > 200
> > ALTER TABLE REPFAX ALTER COLUMN EMAIL VARCHAR(200)
> > I've tried all vesions and perversions of it on SQL7 but keep gettign
the
> > error that there is something wrong around COLUMN
> >
> > David A. Beck
> >
> >
>