Error Code: 80040E14

[ErikEJ]

edit log table:

level nvarchar 10 True False 0 0

execute code:

-- Script Date: 5/8/2015 4:06:13 PM - ErikEJ.SqlCeScripting version 3.5.2.49
ALTER TABLE [log] ALTER COLUMN [level] nvarchar(10) DEFAULT '11' NOT NULL ;
GO

get message:

Error Code: 80040E14
Message : There was an error parsing the query. [ Token line number = 1,Token line offset = 53,Token in error = DEFAULT ]
Minor Err.: 25501
Source : SQL Server Compact ADO.NET Data Provider
Num. Par. : 1
Num. Par. : 53
Err. Par. : DEFAULT

comments

ErikEJ wrote May 10 at 6:51 AM

Thanks for reporting this - assume you are using the GUI to change the column?

Looks like this should be what was actually generated:

ALTER TABLE [Elmah] ALTER COLUMN [Host] nvarchar(50) NOT NULL;

ALTER TABLE [Elmah] ALTER COLUMN [Host] SET DEFAULT ('11');

[ErikEJ]

Turns out this was typed, not generated!