dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: A list of database names

  1. #1
    Walidof Guest

    A list of database names


    hi ,
    I want to create a login component to an sql server data base.
    I use vb6.0.
    Please can someone help me to extract a list of data base only by providing
    a valid Server name.
    I tried to use sp_help but it seems that there is a privilege problem.
    I saw the code of sp_help, it uses a System table.But,I prefer avoiding system
    tables at this level.
    If there are many solution,I'm very grateful.
    sinceraly
    wk

  2. #2
    Michael Levy Guest

    Re: A list of database names

    The system stored procedure sp_helpdb will return a recordset containing
    info about all the databases on the server.

    -Mike
    --
    Michael Levy MCSD, MCDBA, MCT
    Consultant
    GA Sullivan
    michaell@gasullivan.com




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center