-- Useless code

-- SELECT DB_NAME() is enough 

SELECT DB_NAME(DB_ID()) AS [Current Database];

GO

SELECT [name] AS [Current Database]

FROM sys.databases

WHERE database_id=DB_ID();

GO

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro