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…

23

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…

6

Database Publishing Wizard – CTP2

Our web hosting team within SQL Server has reached another milestone with the second CTP of the Database Publishing Wizard. Congratulations to the team! Here is the announcements in their own words explaining some of the updates and changes.  – Mike Today, we’re excited to announce the release of the 2nd CTP of the SQL…

2

SQL Express SP2 – November CTP now available

The November CTP of SQL Express SP2 is available at a download center near you. As I’ve written before, SQL Express SP1 has a few known issues when running on Windows Vista, SP2 is where we’ve addressed these issues and is what we recommend using for Vista compatibility in your applications. The CTP is available…

1