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)
That sure would make tempdb big, wouldn't it? I don't have that kind of disk space. You might have to bounce the service some time before you get there.