4

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

select dbid, name
into #dbs
from master..sysdatabases
where name not in ('Data.StackExchange', 'master', 'model', 'msdb', 'tempdb')


declare @id int, @db varchar(40), @sql varchar(100)

while (select count(*) from #dbs) > 0
begin
  select top 1 @id = dbid, @db = name from #dbs
  set @sql = 'print ''' + @db + ''''
  exec (@sql)
  delete from #dbs where dbid = @id
end

view current version

edited aug 22 14

created aug 22 14 TheBanana