Using DB_ID and DB_Name Functions

Simple but effective, DB_ID and DB_Name give you a concise way to look up the id of a database from a name, or look up the name of a database from an id. There are times when you'll need to write the join to sys.sysdatabases, but when all you need is a quick conversion, these functions get it done.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Steve Culshaw on 3/5/2010

Nice neat nugget on SQL

Puneet K Pandey on 3/5/2010

i am not able to listen coz sound is not coming.

Hans Moviat on 3/5/2010

What would have been very nice is to directly connect it to an urgent problem like "who is hogging up all the processor resources...?"

Andre on 3/5/2010

Thanks

kathy goddard on 3/5/2010

can't see the video

Martin Miller on 3/5/2010

Thanks Andy

Mark Hions on 3/5/2010

Simple concept, explained simply

Mark Sopczak on 3/12/2010

Interesting. I have used SP_HELPDB to get the same info for years.