Microsoft SQL Server Support Blog
SQL Server information from the folks at Microsoft Support
Creating HTTP endpoint fails with 7850 error.
Creating a HTTP endpoint in SQL Server 2005 or SQL Server 2008 may fail with the following error...
Author: SQL Server Support Content Date: 01/07/2010
Tools of the Trade: Part IV - Developing WinDbg Extension DLLs
A WinDbg extension DLL is set of exported callback functions for implementing user defined commands...
Author: SQL Server Support Content Date: 12/30/2009
How to connect to file-based data sources (Microsoft Access , Microsoft Excel and Text files ) from a 64 bit application
The Issue:A 64-bit process can load only 64-bit components in it's process boundary. Same is true...
Author: SQL Server Support Content Date: 12/29/2009
SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed
There is a known issue with SQL Server setup when MSXML6 component update has been installed on the...
Author: SQL Server Support Content Date: 08/28/2009
How to configure SQL server to listen on different ports on different IP addresses?
Technorati Tags: SQL Port The following post describes how you can configure your SQL Server to...
Author: SQL Server Support Content Date: 07/17/2009
Dealing with very large SQL Compact database files
Working with very large SQL Compact files, you may run into two issues: 1. Manipulating a large SQL...
Author: SQL Server Support Content Date: 07/14/2009
Performance: Tips for faster download of a large SQL Compact 3.5 database via Replication
SQL Compact 3.x Replication initial subscription is resource-intensive and may take significant time...
Author: SQL Server Support Content Date: 06/24/2009
SQL Compact Performance: PostSyncCleanup to turn off UpdateStatistics during initial download of SQL Compact Replication
SQL Compact Replication initial subscription may take significant time on devices. The...
Author: SQL Server Support Content Date: 04/15/2009
Class not registered error after restoring an Analysis Services database that uses the SQL Server 2005 SQL Native Client.
After restoring an Analysis Services database that uses the SQLNCLI.1 SQL Native Client (SNAC) on a...
Author: SQL Server Support Content Date: 04/15/2009
After Installation of .NET Framework 3.5 SP1 (or .Net framework 2.0 SP2) , SSIS packages using ODBC 3rd party drivers may fail
The Issue: In the last few months, we have seen quite a few cases where after installing .net...
Author: SQL Server Support Content Date: 04/09/2009
Plan guides (plan freezing) in SQL Server 2005/2008
SQL Server 2005 The plan guides were first introduced in SQL Server 2005.You may find...
Author: SQL Server Support Content Date: 02/19/2009
Reporting Services Staaaarrrrrtttt Up
I hear the complaint a lot that after a time period of no calls to Reporting Services, the first...
Author: SQL Server Support Content Date: 11/09/2007
Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases...
An Analysis Services 2005 query against a calculation on a cell may report the error: "The...
Author: SQL Server Support Content Date: 11/06/2007
General network errors (GNEs), Timeout expired, SQL Server not found or Access Denied…
Many times, the key to solving these errors is a network packet trace. The problem is that these...
Author: SQL Server Support Content Date: 09/06/2007
SQL Server Support FAQ
How often should I expect to hear from my Support Engineer?This will vary based on the issue and its...
Author: SQL Server Support Content Date: 08/16/2007
Tools of the Trade: Part III – Kerberos (I)
In this series of posts, we’re going to take a look at some of the tools we at Microsoft...
Author: SQL Server Support Content Date: 04/16/2007
Tools of the Trade: Part II – The Repro
In this series of posts, we’re going to take a look at some of the tools we at Microsoft...
Author: SQL Server Support Content Date: 04/16/2007
WHITEPAPER - Online Indexing Operations in SQL Server 2005
I wanted to post a quick blog about a new whitepaper from Microsoft.Introduced in Microsoft SQL...
Author: SQL Server Support Content Date: 03/26/2007
SQL 2005 SP2 is available now!
Finally, after rounds of CTPs (Community Technology Previews) and great feedback from customers, we...
Author: SQL Server Support Content Date: 02/19/2007
PART II - Data security enhancements in SQL Server 2005
In the previous edition (Data security enhancements in SQL Server 2005) , we talked about data...
Author: SQL Server Support Content Date: 02/16/2007
Tools of the Trade: Part I – Universal Data Link Files
The other day I was working on an issue with one of our customers. I had been having him run several...
Author: SQL Server Support Content Date: 02/16/2007
SQL Server 2000/2005 and DST changes
Background In August of 2005 the United States Congress passed the Energy Policy Act, which changes...
Author: SQL Server Support Content Date: 01/29/2007
How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?
Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers....
Author: SQL Server Support Content Date: 12/06/2006
We upgraded our servers to Windows 2003 SP1, and now our data-driven application fails with strange errors!
Problem Description After upgrading an application server or database server to Windows 2003 SP1,...
Author: SQL Server Support Content Date: 11/15/2006
Tracking License Information in SQL 2005
SQL 2005 no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still...
Author: SQL Server Support Content Date: 11/10/2006
Installing MS06-061 on NT4
When installing MS06-061 for MSXML4 SP2, you may receive the following error when trying to run...
Author: SQL Server Support Content Date: 11/10/2006
Changing the location of Log files for SQL Server Reporting Services
I have found a few occasions where I have needed to change the location of my Reporting Services...
Author: SQL Server Support Content Date: 11/03/2006
PART I - Data security enhancements in SQL Server 2005
In this two part series, we will talk about data encryption and its implementation in SQL Server...
Author: SQL Server Support Content Date: 11/02/2006
Why is the Initialization checkmark sometimes grayed out in Reporting Services 2005 Configuration Manager?
Just a quick post for Reporting Services. If you are using the Standard edition of Reporting...
Author: SQL Server Support Content Date: 10/23/2006
401.1 when trying to access reports from client machines
A lot of times, we will see this issue manifest itself where reports run fine from the web server...
Author: SQL Server Support Content Date: 10/16/2006
“Unexpected error occurred” during SQL Server 2005 SP1 install.
When you are trying to install SP1 you may see “Unexpected error” message. This error...
Author: SQL Server Support Content Date: 10/09/2006
Help! All of my reports fail with an authentication failure!
Have your Reporting Services 2005 reports started failing recently with the error message? Logon...
Author: SQL Server Support Content Date: 10/08/2006
MSDTC and SQL Server on a cluster
Through this blog, we will try to address commonly asked questions about MSDTC and SQL Server on a...
Author: SQL Server Support Content Date: 10/06/2006
SQL Server and Network Attached Storage (NAS)
Through this blog, we will address some of the commonly asked customer questions on SQL Server and...
Author: SQL Server Support Content Date: 10/03/2006
SQL Server databases are not supported on compressed volumes
It is important to understand that SQL Server database on compressed volumes are not supported. This...
Author: SQL Server Support Content Date: 10/02/2006
SURVEY – Let us know what you think about Query Notification in SQL 2005
We need your help! We want to hear from you about our products and your experience with them....
Author: SQL Server Support Content Date: 09/30/2006
WHITEPAPER - SQL Server 2005 Upgrade Technical Reference Guide
If you haven’t read this whitepaper, read it now. This is a comprehensive upgrade guide that...
Author: SQL Server Support Content Date: 09/29/2006
Error message on launching Management Studio (and other tools in SQL 2005)
We have seen many customers call in for this issue - launching SQL Server 2005 Tools (like...
Author: SQL Server Support Content Date: 09/28/2006
Co-existence of SQL 2005 with SQL 2000
We get several calls related to setup and installation questions. One such common question is...
Author: SQL Server Support Content Date: 09/27/2006
Installing SQL 2005 using ISO images
If you have received SQL Server ISO images (as part of your MSDN subscription or as downloaded from...
Author: SQL Server Support Content Date: 09/26/2006
WHITEPAPER – Working with Tempdb in SQL 2005
Tempdb has undergone a number of changes in SQL Server 2005. Planning for tempdb deployment,...
Author: SQL Server Support Content Date: 09/25/2006
Microsoft Connect - Submit bugs for SQL Server 2005 Online
Yes, you heard it right. If you have run into an issue with SQL Server and feel that it is a bug...
Author: SQL Server Support Content Date: 09/24/2006
WHITEPAPER – Physical Database Storage Design
This whitepaper helps database architects and administrators configure Microsoft SQL Server 2005...
Author: SQL Server Support Content Date: 09/23/2006
Why is a SPID blocking itself in sysprocesses? How is it possible?
After you apply SQL 2000 Service Pack 4, you might observe that a SPID is blocking itself, as...
Author: SQL Server Support Content Date: 09/21/2006
WHITEPAPER - SQL Server I/O Basics
Ever wondered how SQL Server manages I/O to your disk system? Seen errors like 823, 824 and wondered...
Author: SQL Server Support Content Date: 09/20/2006
FAQ - Configuring Log Shipping in SQL Server
Through this blog, we will try to address common customer questions on log shipping in SQL 2005. Can...
Author: SQL Server Support Content Date: 09/19/2006
WHITEPAPER - Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
SQL Server collects and maintains statistical information about indexes and column data stored in...
Author: SQL Server Support Content Date: 09/19/2006
My database file is marked with automatic growth of XXXX% (e.g. 12800%). What’s going on?
You might run into a situation wherein the value of the auto-growth increment of your database files...
Author: SQL Server Support Content Date: 09/18/2006
Why is my transaction log file growing rapidly? How do I stop it from eating up all my disk space?
This is a very common scenario and generates quite a few calls for us. SCENARIOTransaction log file...
Author: SQL Server Support Content Date: 09/18/2006