select object_id("master.dbo.sysobjects") -- 1
select object_id("master..sysobjects")    -- 1
select object_id("tempdb..sysobjects")    -- 1
select object_id("sysobjects")            -- 1

select object_id("master.dbo.syscolumns") -- 3
select object_id("master..syscolumns")    -- 3
select object_id("tempdb..syscolumns")    -- 3
select object_id("syscolumns")            -- 3

select object_id("master.dbo.myTable")    -- NULL
select object_id("master..myTable")       -- NULL
select object_id("tempdb..myTable")       -- NULL
select object_id("myTable")               -- NULL

select object_id("roger")                 -- 400056511