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