How to: Install Query Analyzer (SQL Server Compact Edition)
If you use Microsoft Visual Studio to build a .NET application that uses Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition), and you deploy the application in debug mode, the SQL Server Compact Edition engine and Query Analyzer are automatically installed on the device. You can also install the Query Analyzer by copying the .cab file to the device. If you are building a native application, you must manually copy the .cab file.
SQL Server Compact Edition Query Analyzer is not available with Smart Phone 2005.
To manually install the Query Analyzer
Install the .NET Compact Framework on the device. Copy the following file to your device:
\Program Files\Microsoft Visual Studio 8\SDK\version\CompactFramework\WindowsCE\platform\processor\NETCFversion.platform.processor.cab.
On the device, click the .cab file to install the .NET Compact Framework.
Copy the sqlce30.dev.ENU.<platform>.<processor>.cab file to your device from the following directory:
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\platform\processor\
On the device, click the .cab file to install the Query Analyzer.
A shortcut to Query Analyzer is added to the Start menu of the device.