ALTER current database without using its name

Question

I need to run update script on current database (ALTER DATABASE...), but can't use implicit its name. Is possible to use some function to get current db name and use inside ALTER DATABASE (Sql Server 2005 and above) ? I tried use db_name(), but doesn't work.

select db_name(); works

ALTER DATABASE db_name() ... doesn't work

Answer 1

Actually something more like this is probably a little better if you're altering the current database:

ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 90

Answer 2

You need to use something like

declare @dbname varchar(100) set @dbname=quotename(db_name()) exec('alter database '+@dbname+' ...'); 

or.. even simpler

set @sql='alter database '+quotename(db_name())+' ...'; exec(@sql)