From: genew@ocis.net   
      
   On Tue, 17 May 2011 23:07:49 +0200, Erland Sommarskog   
    wrote:   
      
   >avcitamer (ttavci@gmail.com) writes:   
   >> I need to compile stored procedures and functions larger than   
   >> 8000bytes on Sql Server 2005.   
   >> I even tried CLR procedure, but unfortunately it didnt work.   
   >> what can I do. Please help me.   
   >   
   >Not sure that I understand where the problem is. In the system I work   
   >with, there is a stored procedure which is 3806 lines long, and some   
   >160.000 bytes in size.   
   >   
   >Could you describe your problem in more detail?   
      
        I suspect that he is storing code in a database.  Does SS 2005   
   have varchar(max)?   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)