Category Archives: Bug

SQL Server 2005 – Failed Maintenance Job

Posted on August 27, 2017 by

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading →

Posted in Bug, Error Log, Limitation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

Sql Cluster Resource not comming online

Posted on February 22, 2014 by

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading →

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

Denali — Day 1: Tempdb Compatibility – Bug?

Posted on May 1, 2012 by

Denali — Day 1: Tempdb Compatibility – Bug?   I have installed sql server 2012 express and evolution edition on my personal laptop, and observed that the compatibility of databases is 110 (11) for Denali. And till now when you … Continue reading →

Posted in Bug, Denali, TempDB, Whats New | Tagged , | Leave a comment

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Posted on March 14, 2012 by

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets fails with the following error Message: Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit  … Continue reading →

Posted in Bug, Limitation | Tagged , , | Leave a comment

Day 30: More Fatal Errors and BUGs

Posted on November 30, 2011 by

Day 30 More Fatal Errors and BUGs For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record  structure(for sql server 2005 onwards you may get 824). Msg 5242, Level 22, State 1, Line 1 … Continue reading →

Posted in Bug, Troubleshooting | Tagged , | Leave a comment

Day 4: Service Broker Disabled for MSDB

Posted on November 4, 2011 by

Description:- SNTP related jobs which sends notification failed email failing with following error: Message Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery. [SQLSTATE 42000] (Error 14650).  The … Continue reading →

Posted in Bug, Troubleshooting | Tagged , | Leave a comment

Maintenance Plan "No description found" error

Posted on August 31, 2010 by

for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description found” and you cannot edit the Maitainance plan. problem could be the software you install is confilicting with sql server … Continue reading →

Posted in Bug, General, Installation, What I learned today | Tagged , | Leave a comment