Question:What is the difference between sysobjects and sys.objects? Answer: SQL Server Books Online is the best source of information about system tables. In summary: 1) From SQL Server 2005 , a number of system tables were implemented as compatibility views – satisfying backward compatibility. Sysobjects is an example of a backward compatibility view. Sysobjects is not a table but a view 2) The compatibility views expose the equivalent of the SQL Server 2000 metadata but don’t expose the SQL Server 2005 features metadata 3) If using new features , such as Partitioning , use sys.objects rather than compatibility views 4)... Read more →