Frequently Asked Questions Answered (Updated for 2008)

Question

I've created a FAQ category on the SQL Express Team Blog in order to help track answers to common questions. You can see all the posts that represent FAQs by clicking the FAQ link in the blog or by going directly to: http://blogs.msdn.com/sqlexpress/archive/category/6103.aspx

 

I'm starting to add some 2008 FAQs as the show up in the forum. Keep checking back for new posts.

 

SQL Server 2008 Express

1. How do I troubleshoot the dreaded 'corrupt file' message from the Express Installation Package?
2. Is there a way to install the prerequisites automatically when I install SQL Express?
3. What are the features of each SQL Express edition?
4. How do I upgrade from one edition to another?

Previous FAQ answers

1.  
   1. How do I enable remote connections in SQL Express?
   2. Why isn't my data saved when I'm in Visual Studio?
   3. Why can't BIDS find devenv.exe after installing the Toolkit?
   4. How do I detect if SQL Express is installed?
   5. How do I do a silent install of SQL Express?
   6. How do I work with Windows Vista UAC in SQL Express SP1?
   7. How do I connect to a User Instance in Management Studio?