Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server 7.0, PB with SQL script generation

0 views
Skip to first unread message

Jean Robert Gruser

unread,
Jul 2, 1998, 3:00:00 AM7/2/98
to

When changing a table structure in SQL Server 7.0 beta 2
the generated script looks like :


CREATE TABLE dbo.Tmp_Utilisateurs_diffusion
(
Id int NOT NULL,
FirstName varchar(255) NULL,
LastName varchar(255) NULL,
Email varchar(255) NOT NULL
) ON [default]
TEXTIMAGE_ON [default]
GO

I have the error :

- Unable to modify table.
ADO error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect
syntax near 'TEXTIMAGE_ON'.

It is working when I remove the 'TEXTIMAGE_ON [default]'

The documentation says :

>TEXTIMAGE_ON
>Are keywords indicating that the text and image columns are stored on the specified >filegroup. This will be implemented in a future beta.

So this feature is not implemented but also generated : then it produces
an error.

Do you have any idea how to deal with that ? (Now, I store the file and
I correct
the file by hand and do the rest of the script manually, it is quite
uneasy !!!)

--
A bientot

Jean-Robert Gruser (j...@netforce.fr)

Netforce (http://www.netforce.fr/)
35, rue des Petits Champs
75001 PARIS
Tél.: 01 42 60 59 59 Fax.: 01 42 60 58 00

Eric Miner

unread,
Jul 2, 1998, 3:00:00 AM7/2/98
to Jean Robert Gruser

Since MSSQL 7.0 does not use segments or devices what happens if you
leave off the ON syntax?

Eric

0 new messages