Eis algumas limitações que caso se deparem com elas podem vir a dar muitas dores de cabeça a detectar. Saber que existem é meio caminho andado para resolver o problema.

Entity                        Max Permissible Size
Site Name                    128 characters
Site URL                 255 characters
Display name                 128 characters
Connection string                 384 characters
Email address                    128 characters
Version numbers                064 characters
Virtual Server Friendly Name            064 characters
SQL Database Name                123 characters
SQL Database Column                128 characters
SQL Database Table Name            128 characters
SQL Role Name                    128 characters
Server Name                    128 characters
Windows User Name                300 characters
Windows Password                300 characters
Dependencies per object            032 objects
Zone enumeration value            004 zones
Default SQL command timeout             300 seconds
Number of simultaneous
workflows that can be run             015

Post original em http://blogs.msdn.com/harsh/archive/2007/03/21/sharepoint-2007-maximum-limitations.aspx