Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Getting a list of databases

deostrolldeostroll Member Posts: 65
Is there a query to retireve a list of all user created databases (not tables) in sql server 2000.

Comments

  • NnythingNnything Member Posts: 2
    : Is there a query to retireve a list of all user created databases
    : (not tables) in sql server 2000.
    :
    use master

    select *
    from sysdatabases

  • GiveAHootGiveAHoot Member Posts: 1
    : use master
    :
    : select *
    : from sysdatabases
    GO (Added this)

    That works great, thanks! And I wasn't even struggling with that problem, but when I found this nice clean SQL query, I had to acknowledge your effort.
Sign In or Register to comment.