Very Stranger Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Very Stranger Error

Author

Topic

joni
Yak Posting Veteran

50 Posts

Posted - 2007-03-14 : 09:11:08

Hi gurus,

When I execute the following command in SQL Server 2000 it work well.

ALTER TABLE SALA
DROP COLUMN SALA_TEM_QUADRO

The command(s) completed successfully.

When I execute the same command in SQL Server 7.0 I receive the following error.

ALTER TABLE SALA
DROP COLUMN SALA_TEM_QUADRO

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'SALA_TEM_QUADRO'.

Anybody know what is wrong?

Thank´s

Joni

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-14 : 09:23:46

Check whether your database in not running in the compatibility level below 7.0

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

joni
Yak Posting Veteran

50 Posts

Posted - 2007-03-14 : 09:45:40

Thank´s harsh_athalye,

The compatibility level of my DB was 6.5. Now I change it and work well.

Thank you very much for help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources