How can I switch current database in a script?

USE @variable does not work

I tried the following and id did not work either:

declare @dbnum char(1), @path varchar(20), @db varchar(20), @sql
varchar(1024)
set @dbnum = 1
set @db = 'DMPVTRN' + @dbnum
set @path = 'pvtrn' + @dbnum + '.ip'
set @sql = 'use ' + @db
select @db, @path, @sql
exec (@sql)
GO


Thanks,
Slav.

MS Sql Server LazyDBA home page