Limit to number of functions in a DB

Hello,
Is there a limit to the number of user-defined functions one can have in a
database (i.e. 500 udfs per db)?
Thanks in advance for your help,
-CollinThe limit, AFAIK, is the number of objects (including tables, stored
procedures etc), which is the datatype for object id in sysobjects, which is
in, which mean about 2 billion. From BOL:
Objects in a database 2,147,483,6474 2,147,483,6474
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\arc
hitec.chm::/8_ar_ts_8dbn.htm
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"cc_gardner" <collin_gardner@.hotmail.com> wrote in message
news:buouvr$bjq12@.kcweb01.netnews.att.com...

quote:

---

> Hello,
> Is there a limit to the number of user-defined functions one can have in a
> database (i.e. 500 udfs per db)?
> Thanks in advance for your help,
> -Collin
>

---