Obtener el nombre de la BDD

Declare @dbname varchar(40)
Select @dbname = case when dbid = 0 then null
                        when dbid <> 0 then db_name(dbid)
                        end
from  master.dbo.sysprocesses where Spid = @@Spid
Select @dbname