/ Snippet Library - View Code

Visual Basic / Database / Show All SQL Servers in a domain

Snippet details

ID: 396

Viewed: 1355

Added: 2002-08-19

Version:

Snippets in this catagory
Show Printable Version

Show All SQL Servers in a domain

General Details

Snippet uploaded by: snippet

Email : webmaster@snippetlibrary.com

Snippet By: Unknown

Snippet By:	Unknown
Declarations
Highlight Allnone
Code
Highlight All'Tip: Code For Getting Available SQL Server Names In Visual Basic 'October 10, 1999 'Add this code As a reference To the Microsoft SQLDMO Object Library (SQLDMO.DLL). Dim SQLApp As SQLDMO.Application Dim Names As SQLDMO.NameList Set SQLApp = New SQLDMO.Application ' get available servers Set Names = SQLApp.ListAvailableSQLServers Dim indx As Integer ' print names to debug window For indx = 1 To Names.Count Debug.Print Names.Item(indx) Next Set Names = Nothing Set SQLApp = Nothing This tip was submitted by Kristjan Kelt.

No Reviews to show