ssms - Does SQL Server Management Studio 'Messages' output window have a size limit? -

if outputting messages print or raiserror there buffer size limit window , if can changed.

i've looked everywhere , can't see wood trees!

calification: i'm intested in amount of data output window can display before start removing earlier displayed messages. keeps going there must limit, no?

i don't think there limit other limit imposed available memory in machine. if there 1 high enough cater potential use cases. take sql example:

declare @count int  set @count = 0  while (@count < 80000)  begin  print cast(@count varchar(10)) + replicate('x', 7900)  set @count = (@count + 1)  end 

this print 80000 rows of ~7900 characters. in test each row shown in messages output window (takes while run though). if there limit quite high.

edit

it worth mentioning both print , raiserror truncate if output string long. example

print replicate('x', 7997) + 'end' -- output : ...xxxxend print replicate('x', 7998) + 'end' -- truncated output : ...xxxxen  declare @err varchar(max) set @err = replicate('x', 2044) + 'end' -- total length 2047 raiserror(@err, 1, 0) -- output : ...xxxxend  set @err = replicate('x', 2045) + 'end' -- total length 2048 raiserror(@err, 1, 0) -- output truncated ellipses : ...xxxx...