Determine name of current DB

[gny]

Hi!
I need to pass the name of the DB as a parameter from a stored proc to another, but for some reason I can't get it to work.

When I run the code below, the string 'db_name' is passed, not the database name. It seems SQL server converts

db_name

to 'db_name'. Any ideas?

EXEC dbo.usp_Logout db_name

When I try to print

db_name

instead of passing it, I get the following error message:

"The name 'db_name' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted."

 

[LFCfan]

If i'm not mistaken, this might work:

declare @str varchar(300)
set @str = db_name()
exec dbo.usp_Logout @str

Hope this helps
LFCfan

 

[JamesLean]

Firstly, db_name is a function so you need to include parentheses after it:

PRINT db_name()

To send it as a parameter you need to assign it to a variable first:

DECLARE @db sysname
SET @db = db_name()
EXEC usp_logout @db

--James

 

[gny]

Thanks alot guys, it's working now.