Finding an object name and ID

Use object_id() and object_name() to identify the ID and name of an object. For example:

select object_id("titles")
----------
  208003772

Object names and IDs are stored in the sysobjects system table.