February 10, 2009 at 9:15 am
I get the following error after I sync to a Windows Mobile 5 database. I am currently on SQL Server 2005 (SP2) and Visual Studio 2005. Originally I added the column to the server table via the Design function of the table. I have tried sp_repldropcolumn and then sp_repladdcolumn. Also, I have unchecked the column in the Publication properties->Articles->Objects to Publish and Reinitialized all Subscriptions (with new snapshot) but the changes do not update on the mobile database's schema. Also the mobile database currently has new records/transactions to be uploaded. I hope I do not have to tell the client to erased the database and re-sync.....Any help???
Error Message:
Alter table only allows columns to be added which can contain null values. The column cannot be added to the table because it does not allow null values. (Min. Err.: 25582)
The SQL statement failed to execute [SQL statement = alter table " " default((10))]
February 10, 2009 at 10:24 am
I was able to work around the error by dropping/deleting the Publication and restarting it using generated scripts. I had to start the snapshot agent again as well. However I am not currently bringing down the "not null" column to the mobile database and still wondering on how to add the column to the merge publication with out receiving the same error. Any help is still welcome on that issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply