Immediate help about intalling SQL server !

[raminriahi]

I had Sql 7.0 (main) and Sql 2000(eval. version) as an instance installed on my the machine. Sql 2000 was corrupted all of a sudden. I uninstalled it, but after that Sql 7.0 got corrupted too :-(
I uninstalled the Sql 7.0 and it said it's successfully done, but when i wanted to re-install it again, it won't let me(due to some remained key in registry!!). Apparantly the uninstallment was not that much successful as the app. reported :-((
Now i'm basically grounded.
Please help me and let me know what i can do to come over this. If i find a version of sql 2000(even Eval. one) and install it, does it do anything good?

Re-doing the machin is the worst solution(but i have to go through it if it'll be the only one)

Thanks in advance,
Ramin

P.S: it's kind of emergency. please help me ASAP!

 

[nigelrivett]

try deleting

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 7
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServ70

and delete the target installation directory (C:\MSSQL7 by default).

see

http://www.sql-server-performance.com/ac_sql_server_install_7.asp

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.