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

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