SQL Server CE 2.0 Released
        
        By Bill Graziano
            on 17 September 2002 
        | Tags: 
            
            
                
                SQL for CE
            
        
            
        
            
        Microsoft released SQL Server CE 2.0.  SQL Server CE 2.0 includes updates to: 
- Query analyzer. The query analyzer has been updated to improve the user interface for easier object management. 
 - Query processor. The query processor enables you to streamline your code with new intrinsic functions and parameterized queries. 
 - Storage engine. The storage engine includes major improvements to remote data access functionality, including index pulls and UPLOAD-only features. In addition, the storage engine now supports the same number of indexes (249) per table as Microsoft SQL Server. 
 - Connectivity wizards. This step-by-step guide can help you quickly set up your security and connectivity options for data replication. 
 - ISQLW. This on-device query tool enables you to store queries and view the schema on the device.