|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
07-23-2008
| #1 (permalink) |
| | ListInstalledInstance method of SQLDMO.SQLServer2 object Can someone give me an example of how I can use the method ListInstalledInstances of SQLServer2 object in VBScript? I need a list of all SQL instances installed on a server. Thx, Felipe |
My System Specs |
|
07-23-2008
| #2 (permalink) |
| | Re: ListInstalledInstance method of SQLDMO.SQLServer2 object I figured it out! str = "localhost" Set objSQLDMOApp = CreateObject("SQLDMO.SQLServer2") set objInstances = objSQLDMOApp.ListInstalledInstances(str) For Count=1 To objInstances.Count WScript.Echo objInstances.Item(count) Next Thx, Felipe "Carlos Felipe França da Fonseca" <carlosfelipefranca@xxxxxx> wrote in message news:uM$nJRR7IHA.3736@xxxxxx Quote: > Can someone give me an example of how I can use the method > ListInstalledInstances of SQLServer2 object in VBScript? > > I need a list of all SQL instances installed on a server. > > Thx, > > Felipe > |
| My System Specs |
|
07-24-2008
| #3 (permalink) |
| | Re: ListInstalledInstance method of SQLDMO.SQLServer2 object Thanks for sharing your success. It really annoys me when people just post back "solved" without giving everyone else the benefit of their solution. -- Joe Fawcett (MVP - XML) http://joe.fawcett.name "Carlos Felipe França da Fonseca" <carlosfelipefranca@xxxxxx> wrote in message news:#mQWKcR7IHA.4864@xxxxxx Quote: > I figured it out! > > str = "localhost" > Set objSQLDMOApp = CreateObject("SQLDMO.SQLServer2") > set objInstances = objSQLDMOApp.ListInstalledInstances(str) > For Count=1 To objInstances.Count > WScript.Echo objInstances.Item(count) > Next > > Thx, > > Felipe > > "Carlos Felipe França da Fonseca" <carlosfelipefranca@xxxxxx> wrote in > message news:uM$nJRR7IHA.3736@xxxxxx Quote: >> Can someone give me an example of how I can use the method >> ListInstalledInstances of SQLServer2 object in VBScript? >> >> I need a list of all SQL instances installed on a server. >> >> Thx, >> >> Felipe >> > |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Method '~' of object '~' failed | VB Script | |||
| 438 Object doesn't support this property or method | VB Script | |||
| Destroy a Timer object in its callback method | .NET General | |||
| exception when calling a method: object is read-only | PowerShell | |||
