Thanks for that, it's what I did in the end. I got thrown because the Enterprise Manager "create table" scripts were formatted like that, and it worked fine for those.
Is not allowing DTS or direct access through Ent Manager a normal practise by hosting companies? This is the first one I've come across that's made me do this. Urgh. K. :> -----Original Message----- :> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] :> Sent: Thursday, 1 November 2001 8:31 PM :> To: SQL :> Subject: RE: Alter table SQL error :> :> :> 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. :> :> :> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
