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
