Browse by Tags

• General
• Installation
• Microsoft
• Product Info
• Samples
• SQL Server

• Troubleshooting the corrupt file error when using the SQL Server 2008 Express Setup Package

  I've seen a number of people bringing this message up in the forums recently so I thought I would blog about it rather than type the answer over and over. (I'm lazy that way.) Problem When you run the installer you get the following error after the download Read More... Posted Thursday, April 23, 2009 1:31 PM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Installation

• 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 Read More... Posted Friday, October 03, 2008 10:07 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Samples

• FAQ: "Installing" the SQL Server 2008 Express ClickOnce Bootstrapper for Visual Studio 2008 SP1

  Clearly, the names of our components are getting too long, but that's a matter for another post… Many of you have noticed that the VS bootstrapper for SQL Express 2008 (and similarly the bootstrapper for Windows Installer 4.5) are installed by the Visual Read More... Posted Saturday, September 13, 2008 10:01 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ

• 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 Read More... Posted Monday, August 25, 2008 3:26 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Product Info

• Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances

  I've gotten a number of questions recently asking how SQL Express uses resources during idle time, and how that behavior impacts the way SQL Express behaves "on first connection" after being idle for a period of time. While many of these questions have Read More... Posted Saturday, February 23, 2008 11:07 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Product Info, General

• SSMS - How do I toggle the bottom pane that appears after I run a query?

  CTRL - R Read More... Posted Thursday, October 11, 2007 5:45 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, FAQ, Microsoft

• 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 Read More... Posted Friday, August 24, 2007 9:41 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Samples

• FAQ: Problems installing Express SP2 on a machine with ACT! installed?

  Seems like Mike has the info on whats going wrong and how long it will be before its fixed. Read More... Posted Tuesday, April 10, 2007 8:49 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, FAQ, Microsoft

• FAQ: How do I query Active Directory from SQL Server?

  There are several ways but the most commonly used approach of using linked servers hits ona 1000 row limit in the AD OLE DB Provider, here is a solution using SQL CLR, I have not tried it but if it works as advertised then it should help, beware it does Read More... Posted Friday, March 23, 2007 5:50 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, FAQ, Microsoft

• FAQ: How do I connect to Excel 12 in SQL Server Integration Services (SSIS)

  This question has been coming up a lot internally lately, short answer is: Data Source=D:\Test.xlsx;Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties=Excel 8.0; Note that the provider is no longer JET but the new data engine from the office team Read More... Posted Friday, February 09, 2007 10:41 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, FAQ, Microsoft

• FAQ: What impact does querying a DMV have on the system perf/load?

  Linchi continues his excellent series analyzing the impact of new system features in SQL Server 2005 here . Read More... Posted Tuesday, January 30, 2007 2:53 PM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, FAQ, Microsoft

• FAQ: When will there be a Best Practices Analyzer for SQl Server 2005?

  Soon according to Paul . Read More... Posted Wednesday, January 24, 2007 10:25 AM from Euan Garden's BLOG | (Comments Off) Filed under: SQL Server, FAQ, Microsoft

• 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 Read More... Posted Thursday, November 23, 2006 1:33 PM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ

• 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 Read More... Posted Thursday, November 16, 2006 1:38 PM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Product Info

• Getting things working on Vista (aka - Dealing with User Account Control)

  Update: After a recent article on CNNMoney.com (see my post with the link to the article) I thought I would add to this post to clarify that SQL Express SP1 is supported for use on Windows Vista. As discussed in this post, there are some issues that SP2 Read More... Posted Thursday, October 12, 2006 4:26 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ