Need support for your remote team? Check out our new promo!*
*Limited-time offer applies to the first charge of a new subscription only.
10 licenses for the price of 3
40 licenses for the price of 10
//this code below is just to create a temp table to have similar no of columns of sys.objects
select * into #temp from sys.objects
truncate table #temp
//here is just add another column called DBname to hold database name
Alter table #temp
add DBName varchar(100)
//loop through Databases and get sys.objects
insert into #temp
EXEC sp_msforeachdb [select *,"?" AS db from sys.objects]
select * from #temp
Open in new window
select *,cast(' ' as varchar(100)) As DBName
inner join sys.sysdatabases AS sdb ON sdb.dbid = DB_ID()
where 1 = 2
DROP TABLE #temp
EXEC master..sp_MSForeachdb '
IF ''?'' <> ''master'' AND ''?'' <> ''model'' AND ''?'' <> ''msdb'' AND ''?'' <> ''tempdb''
select *,"?" AS db
inner join sys.sysdatabases AS sdb ON sdb.dbid = DB_ID(''?'')
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.