tags:

views:

39

answers:

1

Hi is there is any way to find out the local instaces installed in a single physical machine.

scenario:

Suppose i have installed sqlserevr2005 and sqlexpress on same machine.is there any way to find these instances using SMO..

and i have installed the datafiles of two instaces in different locations.

how to find these datafiles location both at a time

output should be like:

Sqlinstances:

 sqlravikiran
 sqlravikiran\express

files:

D:\datafiles\master.mdf(sqlserver) f:\datafiles\master.mdf(sqlexpress)

how to do this

+2  A: 

Here is a nice article in MSDNMAG and here the intro page on MSDN.

But please try to update and improve your question instead of posting a new and only slightly different one.

Henk Holterman
Hi thanks for info...keep rocking.it helps me a lot..
Cute