March 2007 - Posts
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 synchronising against a SQL Server publication using Merge Replication.
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 commands such as:
ALTER TABLE Orders ADD FK_Customer_Order FOREIGN KEY (CustomerId) REFERENCES Customers(CustomerId)
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 that maybe of interest:
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.
More Posts