Results 1 to 7 of 7

Thread: finding sql databases in a server

  1. Jun 24th, 2010, 10:13 AM #1
    igimanigi
    igimanigi is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2008
    Posts
    162

    finding sql databases in a server

    how can i find the databases that belong to a sql server on the network.
    Reply With Quote Reply With Quote
  2. Jun 24th, 2010, 10:51 AM #2
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: finding sql databases in a server

    Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  3. Jun 24th, 2010, 09:05 PM #3
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: finding sql databases in a server

    Open Management Studio, connect to that instance and expand the Databases node. If that doesn't answer the question you actually want answered, which I suspect it won't, then please restate the question more clearly.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  4. Jun 25th, 2010, 01:42 AM #4
    igimanigi
    igimanigi is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2008
    Posts
    162

    Re: finding sql databases in a server

    ok that was almost funny...i mean i want vb 6 code to list databases that belong to a server...i have written code that lists the sql servers on the network and after picking one server i want to list the databases in it.
    Reply With Quote Reply With Quote
  6. Jun 25th, 2010, 03:53 AM #5
    TysonLPrice
    TysonLPrice is offline
    Wall Poster TysonLPrice's Avatar
    Join Date
    Sep 2002
    Location
    Columbus, Ohio
    Posts
    3,969

    Re: finding sql databases in a server

    EXEC sp_helpdb

    Check out this also:

    http://databases.aspfaq.com/schema-t...my-server.html
    Reply With Quote Reply With Quote
  7. Jun 25th, 2010, 04:09 AM #6
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: finding sql databases in a server

    Check this out also.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  8. Jun 25th, 2010, 04:48 AM #7
    igimanigi
    igimanigi is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2008
    Posts
    162

    Re: finding sql databases in a server

    thanks a lot ...you rock...it turn out to be simpler than i thought.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width