How to change Date Format after installing SQL server

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 you want to do business in…

16

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan MIGHT fail with: “The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)”

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 Package Utility  Version 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.   …

5

Executing BCP fails with SQLState = 37000, NativeError = 4891. Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Insert bulk failed due to a schema change of the target table

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 is more about it.   Error==== The BCP fails with the below error….


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)

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—————————— Cannot connect to SERVERNAMEABC. —————————— ADDITIONAL INFORMATION: The attempt to connect to the report server failed. Check your connection…


HOW TO TERMINATE SQL JOBS AFTER CUT-OFF PERIOD

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 out or even worse hang!  There is no automated method but this is a…