The Truncate table command does not work in SQL CE. A great work around for this is to use “DELETE from [Table]” and then to reset the Identity column if you are using one you can use “ALTER TABLE [TableName] ALTER COLUMN ID IDENTITY (1,1)”
Posted
Oct 09 2008, 01:47 AM
by
CJM