Filtering SQL Server sys.objects by database
Each Database have its own sys.objects, so you have to get the databases from sys.databases, and
select from {dbname}.sys.objects
{dbname} is the name
from sys.databases
Each Database have its own sys.objects, so you have to get the databases from sys.databases, and
select from {dbname}.sys.objects
{dbname} is the name
from sys.databases