用SQL填充列表框(Populating listbox with SQL)

 不知道为什么发生这种情况，它是无证的，但这是一种解决方法。 
 
 在表名中使用三个部分标识符。 考虑到zuserdb存在于所有数据库的dbo模式中。 
 
CREATE TABLE #userid
  (
     dbname   VARCHAR(50),
     username VARCHAR(50)
  )

EXEC Sp_msforeachdb
  'IF ''?'' NOT IN (''master'',''security'',''tempdb'',''model'',''msdb'')
BEGIN
insert into #userid
select ''?'' dbname, username from ?.dbo.zuserdb where username IN (''a1234'',''b1234'')
END'

SELECT *
FROM   #userid

DROP TABLE #userid 
 
 在排除列表中还添加了model和msdb数据库，因为这些数据库也是系统数据库 

Not sure why that is happening it is undocumented, but here is one workaround. 
 
Use three part identifier in table name. Considering zuserdb is present in dbo schema in all the database. 
 
CREATE TABLE #userid
  (
     dbname   VARCHAR(50),
     username VARCHAR(50)
  )

EXEC Sp_msforeachdb
  'IF ''?'' NOT IN (''master'',''security'',''tempdb'',''model'',''msdb'')
BEGIN
insert into #userid
select ''?'' dbname, username from ?.dbo.zuserdb where username IN (''a1234'',''b1234'')
END'

SELECT *
FROM   #userid

DROP TABLE #userid 
 
Added model & msdb databases also in exclude list because those are also system databases