I have two machines running Windows 7, one is an HP other is an ASUS EEEPC Netbook. Both run SQL Server 2008 Developer Ed. and Visual Studio 2008 no...

Joel,

You did hit on the right solution. You also asked a question "why is this preferred over SQL Express?"

The simple answer is, it's not. Not necessarily anyway, as with all...

Chris, your query should have worked, but here is an example from my blog:

http://arcanecode.wordpress.com/2007/04/16/system-views-in-sql-server-compact-edition-tables/

Also be sure to check out the Arcane Lessons link at the top of my blog, I...

You are probably missing Visual Studio Service Pack 1.

See my blog post http://arcanecode.wordpress.com/2007/04/24/sql-server-2005-compact-edition-important-component/ for a complete list of all the components you'll need to use Compact Edition...

I've used SQL Server Management Studio to create and modify SSCE databases, using no SQL. You can also do the same thing with Visual Studio using the Data Explorer. This...

In SQL 2005, dtsrun was replaced with dtexec. dtsrun, if still installed, probably doesn't understand the 2005 package structure.

Try replacing the dtsrun in your package with dtexec and see...

Great find, putting "\" before and after my value fixed it for me.

I found the answer on an MSDN Forum thread, in this article:

http://msdn2.microsoft.com/en-us/library/ms143698.aspx

Follow the instructions in the very first PROBLEM area. Fixing the Distributed Transaction Coordinator resolved the warning...