This came up during an internal thread and I found the data interesting, so I wanted to pass it along.

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

SQL Server 2005 Books Online 

Maximum Capacity Specifications for SQL Server 2005 

The following tables specify the maximum sizes and numbers of various objects defined in Microsoft SQL Server 2005 components.

[...]