TEXTIMAGE_ON error in SQL

Question

TEXTIMAGE_ON error in SQL

Navigation

#1 by (0 votes)

0

CREATE TABLE [dbo].[bosh] (
    [sid] [varchar] (255) NOT NULL,
    [node] [varchar] (255) NOT NULL,
    [pid] [varchar](100) NOT NULL
 CONSTRAINT [bosh_PRIMARY] PRIMARY KEY CLUSTERED 
(
        [sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
) TEXTIMAGE_ON [PRIMARY];

the query is not executed. The following message appears

Can not use TEXTIMAGE_ON when a table has no text, ntext, image, varchar (max), nvarchar (max), non-FILESTREAM varbinary (max), xml or large CLR type columns.

Try inserting only

CREATE TABLE [dbo].[bosh] (
        [sid] [varchar] (255) NOT NULL,
        [node] [varchar] (255) NOT NULL,
        [pid] [varchar](100) NOT NULL
     CONSTRAINT [bosh_PRIMARY] PRIMARY KEY CLUSTERED 
    (
            [sid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
    ) ON [PRIMARY];

in both the query is not executed?

sql

asked by Devid 23.08.2018 в 02:26

source

1 answer

How to list rows combined in reportviewer? uninitialized constant Spree :: CustomModelPingsController :: CustomModelPing

score 0 · Answer 1

The correct form is:

CREATE TABLE [dbo].[bosh] (
        [sid] [varchar] (255) NOT NULL,
        [node] [varchar] (255) NOT NULL,
        [pid] [varchar](100) NOT NULL
     CONSTRAINT [bosh_PRIMARY] PRIMARY KEY CLUSTERED 
    (
            [sid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]