Not a Member Yet,
Click here to Register
How do you like the new design?






ID: 396
Viewed: 3128
Added: Aug 19, 2002
Version:
Snippet uploaded by: snippet
Written By: Unknown
Demo: Sorry, no demo



User Rated at: 0 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

Show All SQL Servers in a domain

Highlight all by clicking in box
<!---Declaration--->
none

Highlight All
<!---Code--->
'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 Comments to show

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.


Replying to a Comment...


Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

© 2002 - 2017 snippetlibrary.com All Rights Reserved. Conditions