A complete uninstall of SQL 2005

I recently re-built my entire system from ground up (new hard drives, OS, etc). I now have the problem of SQL 2005 installed partially, but no way to get the management tools installed. I get an "already installed message when I try". I've never encounted this before on any other SQL install.

Sequence of events. I installed VS 2005 Pro first, then followed by SQL 2005. Somewhere this install didn't work, and I was left with the MS installed thinking I suceeded, yet none of the functions of SQL were worked or more importantly accessable.

I tried to re-install after using the ADD/Remove App from the control panel (which was sucessfull). SQL thought it was still installed. So I uninstalled VS 2005 as well, and deleted any programs in the SQL directory. Then I checked ADD/Remove programs and nothing was showing. The re-install still did not work. My guess is that the registry is still loaded with now useless entries.

Is there any solution left that does not require me to hand delete any SQL registry entries, since that is always a great way to completely kill my system.

Thanks.

Please send email to me and I will forward a script to clean those installed components.

70-444... Case studies, or...?

Took and passed the 70-443 yesterday morning, now just need the 70-444 to complete the MCITP: DBA cert... Was wondering if anybody out there knew if the 70-444 exam used the case study format or ...? Couldn't find that info on http://www.microsoft.com/learning/exams/70-444.mspx.

Thanks.

Justin

Never mind. Took (and passed) the test yesterday morning. I'll consider the lack of replies to my original message a sign that this was something that's not supposed to be discussed, so I suppose I shouldn't mention anything about the format myself.

Good luck to anybody else taking it.

Justin, now with MCITP goodness.

|||

Congrats!

So tell me, what format was the test?

Did it have multiple choice & simulation?

Was it case studies like the 70-443?

Thanks!

4.5 16bit to 9...help!

I am a complete Crystal reports novice and am throwing myself at your mercy...i have a number of reports compiled under Crystal 4.5 16bit years ago by someone who has now left my company. They are compiled reports that run on users machines who don't have Crystal installed..and they have always worked just fine. I now need to get the same reports running under Crystal 9 but the first thing i noticed is that there is no compile report option, i have tried also compiling them under Crystal 7 32 bit but they still do no work. Is there any easy way of getting my 4.5 16bit .rpt's to work under 7 or 9 ?

Help!!I think that saving the report in a later version of Crystal is enough to convert it, but I'm not positive.

Have you updated the users machine to include the version 9 dlls? I know that when I switched from version 6 to version 8.5, I had trouble with a dll called p2smon.dll. Version 6 of p2smon has something in it that my reports utilize that version 8.5 doesn't support. (Like you, the reports I use were created by a person who no longer works at my company).

Here's a link to a thread I've posted about my Crystal problems with backward compatibility. It has links to other threads. Maybe you'll find something useful?

http://www.dev-archive.com/forum/showthread.php?s=&threadid=283044|||Thanks for your prompt reply..i tried various things. One thing i couldn't understand is that In Crystal 7 help one of the runtime files that is meant to be distributed with the report is called crrun32.exe. I can't find a copy of this file anywhere...

3455: Analysis of database is 100% complete

We're running SQL std. ed., v. 8.00.2039, SP4 using 'no-sync' replication (8
sites). In the Application log of the Event Viewer I get the following
message in groups of 3 every 15 minutes, "3455: Analysis of database
XXPROLAW' (7) is 100% complete (approximately 0 seconds)." I can't identify
what is triggering this analysis and it may be interferring with other
scheduled jobs causing them to fail. Couldn't find anything on Google or MS
N
K-base.
--
Steven PattonTry removing Auto Close from the database.
Found on another newsgroup and it works (but I don't know why).

3455: Analysis of database is 100% complete

We're running SQL std. ed., v. 8.00.2039, SP4 using 'no-sync' replication (8
sites). In the Application log of the Event Viewer I get the following
message in groups of 3 every 15 minutes, "3455: Analysis of database
XXPROLAW' (7) is 100% complete (approximately 0 seconds)." I can't identify
what is triggering this analysis and it may be interferring with other
scheduled jobs causing them to fail. Couldn't find anything on Google or MSN
K-base.
--
Steven PattonTry removing Auto Close from the database.
Found on another newsgroup and it works (but I don't know why).