Home Forums Programming SMO/RMO/DMO ListAvailableSQLServers (SQL-DMO) deprecated RE: ListAvailableSQLServers (SQL-DMO) deprecated

  • Thanks Robert. Here's the code that I posted in the second blog I did on that. I find it slightly more useful although SQL Browser has some funny impact on it every once in a while:

    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null

    [Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers() | Export-Csv C:\Temp\LookWhatElseIFound.csv

    @SQLvariantI have a PowerShell script[/url] for you.