title: Create Table Throws a TextImage Error On Creation
body: <p>I have a table which has one field that uses a <code>filestream</code>. When I attempt to insert the table I get this error</p>
  <blockquote>
  <p>Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), non-FILESTREAM columns.</p>
  </blockquote>
  <p>Why?</p>
  <h6>SQL</h6>
  <pre><code>USE [CMMS]
  GO
  
  /****** Object:  Table [dbo].[Ficheros]    Script Date: 05/09/2014 12:48:48 ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  CREATE TABLE [dbo].[Ficheros](
      [IDFichero] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
      [IDDocumento] [bigint] NOT NULL,
      [Fichero] [varbinary](max) FILESTREAM  NULL,
   CONSTRAINT [PK_Ficheros] PRIMARY KEY CLUSTERED 
  (
      [IDFichero] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] FILESTREAM_ON [FILESTREAM_CMMS_DATA],
   CONSTRAINT [IX_Ficheros] UNIQUE NONCLUSTERED 
  (
      [IDDocumento] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] FILESTREAM_ON [FILESTREAM_CMMS_DATA]
  
  GO
  
  SET ANSI_PADDING OFF
  GO
  
  ALTER TABLE [dbo].[Ficheros] ADD  CONSTRAINT [DF_Ficheros_IDFichero]  DEFAULT (newid()) FOR [IDFichero]
  GO
  
  ALTER TABLE [dbo].[Ficheros]  WITH CHECK ADD  CONSTRAINT [FK_Ficheros_Documentos] FOREIGN KEY([IDDocumento])
  REFERENCES [dbo].[Documentos] ([IDDocumento])
  ON DELETE CASCADE
  GO
  
  ALTER TABLE [dbo].[Ficheros] CHECK CONSTRAINT [FK_Ficheros_Documentos]
  GO
  </code></pre>
  <p>When I delete the table and use the script I get this error:</p>
  <pre><code>Mens. 1709, Nivel 16, Estado 1, Línea 2
  No se puede usar TEXTIMAGE_ON cuando una tabla no tiene columnas de tipo text, ntext, image, varchar(max), nvarchar(max), distintas de FILESTREAM varbinary(max), xml o CLR grande.
  Mens. 4902, Nivel 16, Estado 1, Línea 2
  No se encuentra el objeto &quot;dbo.Ficheros&quot; porque no existe o no tiene permisos.
  Mens. 4902, Nivel 16, Estado 1, Línea 2
  No se encuentra el objeto &quot;dbo.Ficheros&quot; porque no existe o no tiene permisos.
  Mens. 4902, Nivel 16, Estado 1, Línea 2
  No se encuentra el objeto &quot;dbo.Ficheros&quot; porque no existe o no tiene permisos.
  </code></pre>
  <p>The application works fine, access to the database and can add files and get it, but I don't know why the script is incorrect.</p>