Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Get databases

Get databases

Scheduled Pinned Locked Moved Database
databasesql-serversysadmin
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Syed Mujtaba Hassan
    wrote on last edited by
    #1

    Hi there, I am new to sql server 2005 can somebody tell me is there any sql command that returns all databases hosted on SQL server 2005.

    Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."

    J S 2 Replies Last reply
    0
    • S Syed Mujtaba Hassan

      Hi there, I am new to sql server 2005 can somebody tell me is there any sql command that returns all databases hosted on SQL server 2005.

      Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."

      J Offline
      J Offline
      John ph
      wrote on last edited by
      #2

      sp_databases - This [system stroed procedure] return's all databases that reside in an instance of Microsoft SQL Server.

      Regards
      J O H N :rose:
      "Even eagles need a push." David McNally


      1 Reply Last reply
      0
      • S Syed Mujtaba Hassan

        Hi there, I am new to sql server 2005 can somebody tell me is there any sql command that returns all databases hosted on SQL server 2005.

        Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."

        S Offline
        S Offline
        shivvish
        wrote on last edited by
        #3

        hi this is available in sql 2000 also sp_helpdb get back for more info.

        S 1 Reply Last reply
        0
        • S shivvish

          hi this is available in sql 2000 also sp_helpdb get back for more info.

          S Offline
          S Offline
          Syed Mujtaba Hassan
          wrote on last edited by
          #4

          OK thanx buddies. So nice of u.

          Mujtaba "If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups