• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

Poll a SQL Server

I haven't hunted around the PAQs, sorry if this question was recently asked, I'm new to the VB topic area.
I'm trying to figure out how to poll the SQL Server for databases.  I
want to display the databases in a dropdown.
TIA, kay
1 Solution
Create a query that does a "select name from sysobjects where type='U'" this will return a result set of the users tables (not system)

 Other types
 S=System Object

 Hope this helps...
kcduncanAuthor Commented:
I asked on behalf of a friend and he said the answer was over his head (I guess maybe more details would have helped??), but he was able to find some answers elsewhere.  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now