SQL Server : Select current DB name

nacrotek · Jul 20, 2005

Is there a hidden @@ variable, sp_ proc, or other feature which you can query to get the name of the current DB?

I'm looking for something like:

declare @currentDBName varchar(100)
select @currentDBName = <get current DB name>

Thanks in advance

NoCoolHandle · Jul 20, 2005

select db_name()

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL Server : Select current DB name

nacrotek

Programmer

NoCoolHandle

Programmer

Similar threads

Part and Inventory Search

Sponsor