Retrieving Database ID in TSQL

[mikemcginty]

This may be simple but I just can't find the solution

How do I programmatically (via TSQL) retrieve the DBID of the SQL database I am currently connected to?

Regards

Mike

When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!

 

[mrdenny]

This will do the trick.

select dbid
from master.dbo.sysdatabases
where name = db_name()

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[JamesLean]

Or just:

SELECT DB_ID()

--James