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
From stackoverflow
-
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.
Cute : Hi thanks for info...keep rocking.it helps me a lot..
0 comments:
Post a Comment