To identify the ID and name of an object, use object_id() and object_name():
select object_id("titles")
---------- 208003772
Object names and IDs are stored in the sysobjects system table.
