Getting a list of databases

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

Comments

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

    select *
    from sysdatabases

  • : 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.

Howdy, Stranger!

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

Categories