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...

quote:

---

> 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...

quote:

---

> 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...
to[QUOTE]
the[QUOTE]
>

---

|||Is the database set to 6.5 compability?
"David A. Beck" <davidb@.beckb.com> wrote in message
news:%23lTlDlc6DHA.2576@.TK2MSFTNGP11.phx.gbl...

quote:

---

> 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...
> to
> the
>

---

|||Yes it is.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:uUJU%23sc6DHA.2908@.tk2msftngp13.phx.gbl...

quote:

---

> Is the database set to 6.5 compability?
> "David A. Beck" <davidb@.beckb.com> wrote in message
> news:%23lTlDlc6DHA.2576@.TK2MSFTNGP11.phx.gbl...
150[QUOTE]
gettign[QUOTE]
>

---

|||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...

quote:

---

> Yes it is.
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:uUJU%23sc6DHA.2908@.tk2msftngp13.phx.gbl...
> 150
> gettign
>

---

|||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...

quote:

---

> 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...
from[QUOTE]
>

---

|||what errors do you get?
"David A. Beck" <davidb@.beckb.com> wrote in message
news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...

quote:

---

> 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...

quote:

---

> what errors do you get?
> "David A. Beck" <davidb@.beckb.com> wrote in message
> news:OeSw$Oc6DHA.2572@.TK2MSFTNGP09.phx.gbl...
to[QUOTE]
the[QUOTE]
>

---

sql