Hi

I need to be able to change/alter a table structure, more specifically, to remove the TEXTIMAGE ON [Primary], see scripted table below,

CREATE TABLE [dbo].[tblwSecondApplicant] (
    [SecondApplicantID] [int] IDENTITY (1, 1) NOT NULL ,
    [FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Occupation] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [DateofBirth] [datetime] NULL ,
    [PassportNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Signature] [int] NULL ,
    [AddressID] [int] NULL ,
    [TelephoneID] [int] NULL ,
    [TitleID] [int] NULL ,
    [ShareHolderID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

How do I go about changing this?



Duncan

__________________
Duncan

The above ddl script is wrong you can't use TEXTIMAGE_ON when a table has no text, ntext, or image columns.

To remove the TEXTIMAGE_ON you just need to remove the text, ntext, or image data types columns from the table.




Cheers,
Pooja Falor