SQL Server Errors Question:
Download Questions PDF

How to solve "The SQL Server service failed to start. For more information, see the SQL Server Books Online topics" error?

SQLServer Errors Interview Question
SQLServer Errors Interview Question

Answer:

Struggled with this one for 2 days and went through tons of
forums till I found this one:

http://social.msdn.microsoft.com/Forums/en-
US/sqlsetupandupgrade/thread/84b399b5-7d7b-46fa-8f86-
8c9af2cbf641

SokSa.Icy had the right idea.

My particular problem also involved going through the
registry to remove all instances of Visual Studio 2008 as
well as a .Net 3.5 hotfix that I could not get rid of.

Once I uninstalled and did everything this guy did, I also
went through the registry and searched/deleted all
instances of the framework hotfix to get it out of the
add / remove dialog box in control panel.

I also used wise registry cleaner to make sure I got all
inconsistencies out of the way, rebooted, and
installed .net 2.0 Express.

After a successful installation, I rebooted again and ran
sql server 2005 express installation and presto - back in
business...

Download SQLServer Errors Interview Questions And Answers PDF

Previous QuestionNext Question
Suppose I have table nametemp in that I wanted to add some partial data for a particular column name policyno where data is existing in that column. Ex.Policyno like R-KT-SK-EA-134526 like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix likeR-KT-SK-EA- now I wanted add this prefix as R-KT-SK-EA-134527 for some 50 records. How can I add partial data?WHAT IS HTTP 500 Internal Server Error? CAN I SOLVE THIS?