Sql Server Compact 35 Sp2 Query Tools

SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices.

MAC Labs: CSIS Classroom Lab CSIS Classroom Lab Meshel Hall rm.

I am provisioning for automated database schema upgrades in a Windows Forms Application (VS2010/VB) which uses SQL Server Compact 3.5 SP2. A portion of the schema upgrade procedure uses TSQL commands passed to SQLCE like the following: cmd.CommandText = 'ALTER TABLE [SaleComps] ADD COLUMN [BldgYOC] int DEFAULT ((0))' cmd.ExecuteNonQuery() This procedure seems to work well with nvarchar() columns, but does work with numeric data types like int and money. Chicche di cala wga crack windows 7. I get the following error from the following SQL commands: Command: ALTER TABLE [SaleComps] ADD COLUMN [BldgYOC] int DEFAULT ((0)); Command: ALTER TABLE [SaleComps] ADD [CEAdjustment] money NULL DEFAULT ((0)); Error: There was an error parsing the query. [ Token line number = 1,Token line offset = 7,Token in error =; ] The TSQL commands were composed from ErikEJ's SqlCE Toolbox schema Diff tool (ExportSqlCe version 3.5.2.15) and work without modification in LinqPad. I have tried different syntax variations (with and without COLUMN keyword; different parenthesis brackets; etc) but cannot get the SQLCE engine to execute the commands which work fine in LinqPad. Is there something wrong with the syntax I am using, or is there some internal conflict with nullable rules?