general rule of thumb: if you need to ask about a limit in sql server then you have a bad design.

from books online:

quote:Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647