What is the maximum character length of object name (e.g. constraint, column) in SQL Server 2008?
128 characters. This is the max length of the sysname datatype (nvarchar(128)).
sysname
nvarchar(128)