Lowell (12/9/2014)

---

you will most likely run out of disk space long before you approach the max number of objects.

this is the max for any database, regardless of being a user db, tempdb, or whatever.

because object_id is an int, the most you can have is select power(2,31) -1

objects or basically 2 billion objects.(2,147,483,647)