MS SQL Server, alter table alter column

alter table alter column

Author	Message
castanz #1 / 4	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

Narayana Vyas Kondredd #2 / 4	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

Nigel Rivet #3 / 4	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

castanz #4 / 4	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

Page 1 of 1

[ 4 post ]