TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vishal Pandey
NA
19
23.5k
Find Local SQL Servers when Off Network
Feb 8 2006 11:09 PM
We use SQLDMO.Application.ListAvailableSQLServers to show a list of all visible SQL Servers. This works great, until the user disconnects his network cable. Now I'd expect to lose the servers on other computers, but we also can't see the servers running on the local box.
After some googling, I'm aware that this is a known issue with ListAvailableSQLServers. Fine. However, if I use Enterprise Manager on the disconnected box, it can see the local instances just fine.
So, anybody here know the magic API call or other technique for listing the SQL Servers on the local box when the network is disconnected?
Reply
Answers (
0
)
Need Help in Excel Interop
How to read a binary file, convert it into proper text format ?