Hello there!
I have on a machine (named SV-ISDEV) two MSSQL instances installed. The
local and the SV-ISDEV\PREPROD. Now I want to unistall the PREPROD
instance.
Which is the correct way to do this?
Do I have to run the installation again?

Thanks

See question 28:

http://support.microsoft.com/default...b;en-us;257716

Simon

Thanks a lot for your help.
I was trying to uninstall the instance using the "Add/Remove Programs"
option from the Control Panel but the procedure cancels due to the
following reason:

the isql.exe is running.

I tried to kill this process but I cannot. I tried to restart the
server but when it boots its started.

Any ideas about what is this and how can overcome it?

Regards


Simon Hayes wrote:
> See question 28:
>
> http://support.microsoft.com/default...b;en-us;257716
>
> Simon

(DMina@laiki.com) writes:
> Thanks a lot for your help.
> I was trying to uninstall the instance using the "Add/Remove Programs"
> option from the Control Panel but the procedure cancels due to the
> following reason:
>
> the isql.exe is running.
>
> I tried to kill this process but I cannot. I tried to restart the
> server but when it boots its started.

ISQL is a command-line program for sending queries interactively to
SQL Server. Have you checked that you don't have any command-line
windows open?

If this is run by some automatic process, check SQL Server Agent
for jobs, the Startup folder and the various Run keys in the
registry for Software\Microsoft\Windows\CurrentVersion.

> Any ideas about what is this and how can overcome it?

Also, the link that Simon gave, included a second link,
http://support.microsoft.com/kb/290991. That appears to be a last
resort.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp