How to select all database names on a server?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

Check out the system table sys.databases.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Paul White SSC Guru Points: 150467 More actions · Answer 2

Even that won't show all the databases on a server.

You need to run:

SELECT * FROM master.sys.sysdbreg;

from the DAC to see the hidden mssqlsystemresource database. 😉

Paul

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

OK, how about "all the databases you should be messing around with" can be accessed through sys.databases? :hehe:

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Paul White SSC Guru Points: 150467 More actions · Answer 4

Grant Fritchey (8/7/2009)
OK, how about "all the databases you should be messing around with" can be accessed through sys.databases? :hehe:

:laugh: better :laugh:

drjdewhurst SSC-Addicted Points: 408 More actions · Answer 5

SSC-Addicted

Points: 408

August 7, 2009 at 8:38 am

Thansk guys