Showing results for 
Search instead for 
Did you mean: 

maximum number of UDFs

Former Member
0 Kudos

Hi all,

I need to know "what is the maximum number of UDFs that could be added to a system table ?"

Its urgent ...



Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Praveen,

What database platform are you using? There is a limitation in SQL 2000 that restricts the overall size of any table row to approx 8K bytes. So if you are using SQL 2000 then any SBO system table, including UDFs, cannot exceed this limit. SQL 2005 does offer some options to get around this restriction (ie the nvarchar(max) datatype).

Kind Regards,


Answers (0)