XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Dear SQLers:   
      
        I have a script that sets up a simple database.  I have various   
   messages in it to indicate what should be happening.   
      
        On inserts that will fail, I put a print statement before.   
             print 'PKPri is a duplicate:'   
             insert ...   
   That shows up the errors nicely.   
      
        On selects, it is not so easy.  I want to see a message that the   
   table should have so many rows, but it does not all show:   
             select 'This message is about the table and is too long per   
   some limit:'   
             select * from Primus   
   I would like to see the full message without having to resize it   
   manually.  Is there any way to do this with *grid* output?   
      
        I would like the answer for SSE 2008 and for 2012.   
      
        I have tried casting, but that does nothing.  (I would think that   
   select  [,] should be an exception and would be displayed   
   in full.  After all, it is always one row.)   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)