Hi Kay If you get rid of the brackets, and the On [Primary] it works fine:
ALTER TABLE stores ALTER COLUMN fax char(20) NULL HTH Dan -----Original Message----- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: 1 November 2001 05:06 To: SQL Subject: Alter table SQL error Hi all, I have a client on a [insert swear word here] host who does not allow DTS transfers for their SQL Server database. Instead, I need to upload sql scripts into a directory on the site, then go to their site administration page and execute it. I managed to create the tables this way, however now I need to alter the length of one of the fields. I have this: ALTER TABLE [dbo].[stores] ( ALTER COLUMN fax char (20) NULL ) ON [PRIMARY] GO When I run this script I get the following error message: Line 2: Incorrect syntax near '('. I have the Osborne book SQL Server 7: a Beginner's Guide, and I can't seem to find why this is not working. Any help would be greatly appreciated! K. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
