Solved

Poll a SQL Server

Posted on 2000-02-23
2
182 Views
Last Modified: 2011-09-20
Hi,
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
0
Comment
Question by:kcduncan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Accepted Solution

by:
mathewss earned 100 total points
ID: 2553397
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
 P=Procedure
 TR=Trigger
 K=Key/Index

 Hope this helps...
0
 

Author Comment

by:kcduncan
ID: 2601949
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.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question