Search code examples
sql-serversql-server-ce

SQL Server CE - Not letting me add a Varbinary column of max length

I've been struggling in vain to add a VARBINARY column of MAX length to my table.

I'm trying with this: 

ALTER TABLE Databases ADD dbFile VARBINARY(MAX)

and it's returning:

There was an error parsing the query. [ Token line number = 1,Token line offset = 44,Token in error = MAX ]

What am I doing wrong?

Solution

  • According to this TechNet page (Data Types Supported in SQL Server CE), SQL Server CE supports varbinary only up to 8000 bytes long.

    If you need a larger column, you have to use image instead.