How to get Database name of sqlserver

Question

How to get Database name of a specific Database in a stored procedure.

score 64 · Accepted Answer · answered Jul 21 '11 at 10:21

64

To get the current database name use select db_name().

answered Jul 21 '11 at 10:21

Mikael Eriksson

score 17 · Answer 2 · answered Jul 21 '11 at 10:43

17

or

select name from sys.sysdatabases 
where dbid=db_id()

or

select DB_NAME(db_id())

answered Jul 21 '11 at 10:43

Madhivanan

2 Answers2