How to check that SQL Server or MSDE is installed?

Hi,

1) How to check that SQL Server or MSDE is installed?
2) How to install MSDE automatically from my setup?

Thank's
Alexei

[137 byte] By [Alexei_shk] at [2007-12-16]
# 1
Hi,

1.] The names of all SQL Server instances on a computer can be found from the InstalledInstances value which is located under the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

You would need to use the namespace Microsoft.Win32 for accessing the registry in .NET

2.] Go through this link:
http://www.microsoft.com/sql/msde/techinfo/reskit/deployreskit.asp

Regards,
Vikram

Vikram at 2007-9-9 > top of Msdn Tech,Visual C#,Visual C# General...
# 2
Here's an article that teaches you how to use the MSDE 2000 Deployment Resource Kit up there.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp

JustinLee at 2007-9-9 > top of Msdn Tech,Visual C#,Visual C# General...
# 3
Hi,

There I have found how to install database on msde. I want to install msde.

Thank's
Alexei

Alexei_shk at 2007-9-9 > top of Msdn Tech,Visual C#,Visual C# General...
# 4
Hi,

This creates the setup but if I have sql server with sp4 it tells me to install old msde. I don't want to install msde where I have sql server...

How can I solev my problem in another way?

Alexei_shk at 2007-9-9 > top of Msdn Tech,Visual C#,Visual C# General...