View Single Post
  #3 (permalink)  
Old 08-16-2010, 03:56 PM
hayabusa hayabusa is offline
BES Activated
 
Join Date: Apr 2009
Location: kansas
Posts: 6
Default SQL script from RIM is below. Make sure and backup DB beofre running....

delete from syncdevicemgmt
where userconfigid in (select userconfigid from syncdevicemgmt where TableId=2 and Data like '%'+'net_module_name'+'%'+1.0+'%')
and
userconfigid in (select userconfigid from syncdevicemgmt where TableId=2 and Data like '%'+'net_module_name'+'%'+2.0+'%')
and
Data like '%'+'net_module_name'+'%'+1.0+'%'
Reply With Quote