Clear data when SQL server CE DB size reaches 4 GB size

• roshanmaugustine

  SSC Enthusiast

  Points: 144

  More actions

  May 20, 2010 at 3:54 am

  #235372

  Hi All,

  How we can clear data from the SQL server compact edition 3.5 sp1 (CE) database when it reaches 4 GB size. I am using SQL server CE in local system and SQL server 2008 enterprise edition (EE) in Server. Whenever network connection available we will transfer data from the CE to EE. We are keeping a copy for later reference in the local db but if it reaches 4 GB how we can clear the data in SQL server CE

  Thanks,

  Roshan

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  May 24, 2010 at 10:31 pm

  #1171836

  Try trigger

• roshanmaugustine

  SSC Enthusiast

  Points: 144

  More actions

  May 26, 2010 at 4:09 am

  #1172569

  We cannot create trigger in SQL server CE