How to find specific database on a server

Question

I am trying to locate one database from my database server. I have 22 different databases on the server. I am using:

select [name] from sys.databases

But this returns all the 22 names. I only need a specific one called "LightBulb".

Anyone knows by any chance? Meanwhile I will keep trying.

Thank you.

I'm a little confused - if you already know the exact name of the database, what's the point of the query? — Damien_The_Unbeliever, Jul 18 '14 at 13:57
in my program I am converting the SQL DB to a different file so I need to execute that particular database. — Victor_Tlepshev, Jul 18 '14 at 14:13

score 1 · Accepted Answer · answered Jul 18 '14 at 13:52

1

select [name] from sys.databases where [name] = 'LightBulb';

answered Jul 18 '14 at 13:52

I can can swear I have tried it and it gave me a column could be found error. Thank you so much. – Victor_Tlepshev Jul 18 '14 at 14:11

1 Answers1