Home Forums SQL Server 2008 SQL Server 2008 - General SQL 2008 query result message tab display limit RE: SQL 2008 query result message tab display limit
Oliiii
SSCertifiable
Points: 5328
More actions
October 5, 2010 at 6:12 am
#1231613
The replicate command truncate to 8000 characters if you are not using varchar(max) or nvarchar(max).
If you use varchar(max) it works fine though:
select len(replicate(convert(varchar(max),1),8005))
Output: 8005