http://blogs.msdn.com/b/euanga/archive/2006/12/08/faq-sql-server-and-sequence-objects-generators.aspxSQL Server 2005 includes a lot of changes to help make moving from Oracle to SQL Server easier, these include; - User Schema separation - Multiple Active Result Sets (MARS) - Synonyms - Recursive Queries(CTEs) and some other smaller issuesen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/euanga/archive/2006/12/08/faq-sql-server-and-sequence-objects-generators.aspx#1717294Mon, 19 Feb 2007 20:14:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:1717294Euan Garden<p>MARS is not supported against CE</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=1717294" width="1" height="1">http://blogs.msdn.com/b/euanga/archive/2006/12/08/faq-sql-server-and-sequence-objects-generators.aspx#1638529Sat, 10 Feb 2007 03:10:06 GMT91d46819-8472-40ad-a661-2c78acb4018c:1638529r.s.<p>Is MARS supported on the sql server compact edition?</p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=1638529" width="1" height="1">