Error messages: The log reader fails with the following error message: ============================================== The process could not execute 'sp_MSpub_adjust_identity' on 'PR2K8\YUKON'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help...

The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download, and includes SQL Server 2005 SP3 cumulative updates 1 to 11, customer requested fixes and the SQL Server 2005 SP4 database engine support for DAC operations...

I have always been a big fan of troubleshooting SQL Server performance issues with the help of DMVs. Not only does this allow me to track down the culprit without the help of any external tools/EXEs but it also gives a sysadmin an unbridled sense of power...

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server. Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following...

When you configure a merge replication with web synchronization using FTP over internet, you might run into an issue when you run the merge agent. Assume that we have configured the merge replication with the above specifications and have run the...

Problem Description ======================================= We encountered a situation where we were trying to execute a maintenance plan to rebuild the index of OperationsManagerDW database. However, the maintenance plan fails to complete. ...

Here is one of the rare scenario on SQL Server memory issue (701 error) caused due service broker misconfiguration or incorrectly used, causing memory object OBJECTSTORE_SERVICE_BROKER to grow and not releasing memory back. Below is the memory error,...

Accessing Linked server using Synonym results in an error after we rebuild Indexes on the target server in SQL Server 2005. The Error Message is like below, Msg 7359, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "Domain...

While installing security patch KB 948109 on the sql server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location C:\Progarm...

When you install SQL Server 2005 Management Studio on Windows Server 2008, you might encounter the following error Error 1935. An error occurred during the installation of assembly 'Microsoft.MSXML,Version="8.0.0.0",Culture="neutral",PublicKeyToken...

As mentioned in my previous posts if the sql server fails to come online we need to start troubleshooting by looking at the sql server error log. So we checked the sql server error log and  found that sql server was started successfully and there...

· Disclaimer : Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office...

I had a situation where I needed to install SQL Server 2008 Express edition with management studio and also upgrade it to SP1 using just one installer. It does not sound impossible as we already have a similar installer that can install SQL Server 2005...

Many a time there is a need to programmatically change in the SQL Server configuration settings. This can be done through the methods exposed via SQL Server’s WMI namespace. The need for this script arose due to a need to change the Port Number of multiple...

Part2 In the part1 we discussed the basic difference between encryption and hashing. So now let’s look into how we can implement hashing and encryption using the SQL server functions. We have a function called the “HashBytes” function which performs the...

For SQL Server 2000: Case 1: If the default instance of sql server is to be upgraded to default clustered instance of sql server 2000 Note: 1) Only Default instance can be upgraded by this method 2) This Functionality is not vailable in...

Troubleshooting tempdb growth due to Version Store usage Recently I worked on an issue where the tempdb database version store cleanup was not occurring. I created a small repro to demonstrate the behavior. My tempdb has been showing the version...

We have observed a number of cases where Sql Server resource fails to come online on Windows 2000 Cluster after applying a security patch. As mentioned in my previous posts whenever a sql server resource fails to come online we should start by checking...

Environment: SQL Server Enterprise Edition 2005 32 bit on Windows Server 2003 Enterprise SP1 Consider a scenario where you are installing SQL Server 2005 Servce Pack 2 on a clustered environment. Sometimes you will notice that the installation get...

We have observed a number of cases where the installation of SP2 succeeds on Active Node while it may fail on the passive node while installing SP2 on the clustered instance of SQL server 2005. In order to find the cause of the failure on passive node...

With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as Server Side Tracing. In this article we’ll talk about how to achieve Server Side Tracing. How to create a Server Side Trace Open SQL Server profiler connect...

Recently I encountered an issue where the in-place upgrade of the SQL Server 2005 to SQL Server 2008 on the Windows Server 2003 cluster failed with following error: TITLE: Microsoft SQL Server 2008 Setup ------------------------------ The...

An overview of the inner working of a replication monitor We might see large number of Pending transactions on one of the Publisher in P2P replication. But when we check the Replication Monitor for second server (Subscriber) it might show a small...

We encountered an interesting issue some time back. We already had XML data inserted into a SQL Server 2008 R2 database however we were getting below error when retrieving (also called shredding) values from the XML data. Msg 8621, Level 17,...

We have observed a number of cases where the installation of the SQL server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected...