FAQ: Error creating a Service-based database in Visual Studio 2008 SP1

A few of you have run into problems when trying to add a new Service-based database to your project in Visual Studio 2008 SP1. This problem has been reported to Microsoft Connect and the Visual Studio team is working on a fix, but I thought I would provide some details on a workaround in the…


FAQ: Switching between SQL Server 2008 edtions

There is an extra step that you need to take when upgrading from one edition of SQL Server 2008 to another, for example when upgrading from Express to Express with Tools. This extra step is called Edition Upgrade (sometimes SKU Upgrade) and the net result is that you have to run the install wizard twice…


What’s up with SQL Server 2008 Express editions

<?xml:namespace prefix = w ns = “urn:schemas-microsoft-com:office:word” /> Microsoft has announced the release of SQL Server 2008 and that means it time for another post about SQL Server Express.<?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /> The press release indicated that SQL Express is already available, but those of you who have followed the link have…


DIY SQL Express SP2 Bootstrapper

I’ve waited far too long to communicate this disappointing news to everyone, so here it is… I’m not going to be releasing the SQL Express SP2 Bootstrapper manifests that I had discussed in a long ago blog posting. I’ll spare you the sob story of my efforts to create this; suffice it to say that…


Connecting to SQL Express User Instances in Management Studio

Many of you are working with User Instances, sometimes without even realizing it. Briefly, a User Instances is special process of SQL Express that can be started by an application at runtime and allows SQL Express to emulate some of the characteristics of embedded databases. User Instances were added to SQL Express in order to…


SQL Express SP2 and Windows Vista UAC

Now that SQL Server 2005 SP2 has been released I thought I should make good on my promise to explain more about how we handle Windows Vista User Access Control in SQL Express SP2. I explained earlier that UAC works by removing the administrator ACEs from your User Token when you are a member of…