November, 2009

In the below blog, I am going to share my experience on one of the unique case which I have worked couple of days back. The issue will arise if you have installed SQL with the default collation and your machine is using English (US). Now say for example...

Setup is ideally supposed to be an easy process, but more often than not we are fraught with a multitude of errors. This blog is intended to make life a little easier when it comes to SQL server setup. When we run SQL 2005 setup we get the following...

Good afternoon techies! I recently worked with some customers on SQL Server 2005 login failure issues. Thought I’d make a blog post on what exactly we do @ PSS in such situations and specifically share my thoughts on login failure issues relating with...

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan fails with below error. This issue is also seen on a newly created a maintenance plan as well. Executed as user: <Domain>\User. Microsoft (R) SQL Server Execute...

BCP is a very commonly used operation and sometime very critical and failure could cause loss of operation time and inconsistent data. Below is one of the cause resulting in bcp operation failure and the error indicates some schema change issue. here...

You encounter report server connection failure with below error message. Below is one of the instance which I witnessed while connecting through SSMS, it fails while using the server name (SERVERNAMEABC) Error: ===== TITLE: Connect to Server --...

NOTE: This method should not be attempted on the following jobs: Ø   Reindex Ø   Update Statistics Ø   Replication Ø   Backup How many times have we encountered a SQL job which runs for a long time (more than expected) only to error...