-
Q: Is there a good whitepaper/documentation that describes the SSCE components? A: Yes there is a knowledge base article, http://support.microsoft.com/?kbid=920700 , lists the major changes (since v3.0), all relevant downloads, performance gains in the...
-
Q: When I go to upgrade my database there are a number of Encryption options. What do they all mean? A: To support older operating systems, with older encryption algorithms, and newer, more secure encryption, SQL Server Compact 3.5 supports backward-compatible...
-
Q: I've attempted to open a v3.1 SSCE database file using the SSCE 3.5 runtime (still in beta) and it is failing? A: Despite using the same extension (ie .sdf) not only are SSCE 3.5 db file not backward compatible with older runtimes, SSCE 3.1 and...
-
1. SQL Server Compact 3.5 for Windows Desktop Beta 2 : Installs the files for SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net for Windows Desktop platform 2. SQL Server Compact 3.5 for Windows Mobile Beta 2 : The download contains...
-
Q: What does the following error message mean? The lock manager has run out of space for additional locks. This can be caused by large transactions, by large sort operations, or by operations where SQL Server Compact Edition creates temporary tables....
-
Q: How do enable compression when using SQL Server Merge Replication? A: There is a property on the SQLCeReplication object appropriately named CompressionLevel that can be used to determine the level of compression that is used. Valid values are 0 (no...
-
Q: A Select statement involving an inner join between two tables, one with an index on the join column and the other has no index, is returning incorrect results? A: There is a known issue which has been acknowledged in this knowledge base article
-
Q: I want to use Merge Replication to synchronise data to my SQL Server CE database. Are there any how-to whitepapers available? A: In addition to the SQL Server 2005 Compact Edition Books Online there is also an article on GotDotNet that walks through...
-
Q: How do I create relationships between tables in SQL Server CE? A: Unfortunately there is currently no designer support (unlike for SQL Server 2005) for building relationships between tables in SQL Server CE. To build relationships you need to use SQL...
-
Q: I'm having difficulty understanding the security model between SQL Server CE, IIS and SQL Server. Are there any good reference papers on this? A: Yes, Microsoft are continually updating Documents Online but there are a couple of additional whitepapers...
-
Q: How do I rename an existing table? A: Although SQL Server Compact Edition does currently support this through the SQL language it is exposed at the lower level as Joao explains in this article across at the Pocket PC Developer Network.
-
Q: I've been using the IsNull function but it seems to be ignoring the second parameter (just returning True or False instead). Is this function supported and/or is there an alternative? A: Officially SQL Server Compact Edition doesn't support IsNull...
-
Q: I've installed all the components for SQL Server Compact Edition yet I'm still getting SQL Mobile appear in the Object Explorer within SQL Server Management Studio (SSMS)? A: In order for the SQL Server Compact Edition elements to appear you need to...
-
Q: Can I use SQL Server Management Studio Express to create and work with SQL Server Compact Edition databases? A: Yes, but not with the original RTM version (available here ). You need to install a version which includes SP2 (currently available as a...
-
Q: Does SQL Server Compact Edition support System.Transactions.Transaction? A: No (as supported by the product team in their comment here ) it is currently not supported in v3.1. Indication is for support in the next version of Visual Studio which should...