Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky Getting The Most Out of SQL Server 2005 UDTs and UDAs RE: Getting The Most Out of SQL Server 2005 UDTs and UDAs

  • June 29, 2009 at 11:28 am

    #1017008

    For those stuck at 8000 bytes setting for MaxByteSize, SQL Server 2008 has bumped this amount to 2 GB! Just set MaxByteSize = -1. Only challenge to this, is you have to deploy the CLR manually, but it's worth it.