alter table alter column 
Author Message
 alter table alter column
I'm having a problem using the alter table command on sql
server 7.0.

When running "alter table test alter column col1 numeric
(10)" the engine returns "incorrect syntax near 'column'
170".

I have used this command on other sql server 7.0 instances
without error. Any ideas on what I'm missing? Is there a
setting somewhere?

Thanks in advance.



Tue, 30 Aug 2005 08:04:37 GMT
 alter table alter column

Looks like this database is upgraded from 6.5 and is currently in 6.5
compatibility mode. You will have to change this to 7.0 compatibility mode
to be able to use new syntax. You can verify and change your database's
compatibility level using sp_dbcmptlevel. See SQL Server Books Online for
more information.
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/


I'm having a problem using the alter table command on sql
server 7.0.

When running "alter table test alter column col1 numeric
(10)" the engine returns "incorrect syntax near 'column'
170".

I have used this command on other sql server 7.0 instances
without error. Any ideas on what I'm missing? Is there a
setting somewhere?

Thanks in advance.



Tue, 30 Aug 2005 08:16:25 GMT
 alter table alter column
Probably 6.5 compatibility mode.

try sp_dbcmptlevel.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Tue, 30 Aug 2005 08:21:04 GMT
 alter table alter column
Thanks. That did the trick!
Quote:
>-----Original Message-----
>Looks like this database is upgraded from 6.5 and is
currently in 6.5
>compatibility mode. You will have to change this to 7.0
compatibility mode
>to be able to use new syntax. You can verify and change
your database's
>compatibility level using sp_dbcmptlevel. See SQL Server
Books Online for
>more information.
>--
>HTH,
>Vyas, MVP (SQL Server)
>SQL Server FAQ, articles, code samples, interview


Quote:
>http://vyaskn.tripod.com/



>I'm having a problem using the alter table command on sql
>server 7.0.

>When running "alter table test alter column col1 numeric
>(10)" the engine returns "incorrect syntax near 'column'
>170".

>I have used this command on other sql server 7.0 instances
>without error. Any ideas on what I'm missing? Is there a
>setting somewhere?

>Thanks in advance.

>.



Tue, 30 Aug 2005 08:29:41 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Help with Alter Table Alter Column

2. Alter Table Alter Column Syntax

3. Alter table alter column

4. Alter table alter column syntax

5. Alter table Alter column problem.

6. ALTER TABLE ALTER COLUMN

7. ALTER TABLE ALTER COLUMN to set Default

8. Alter table alter column text

9. syntax for ALTER TABLE ALTER COLUMN DEFAULT

10. Errors With ALTER TABLE/ALTER COLUMN

11. Alter table alter column

12. ALTER TABLE ALTER COLUMN


 
Powered by phpBB® Forum Software