Errors occurred whilst parsing file c:\XXXX\Local\Red Gate\SQL Source Control 3\Transients\xneywcjt.u5d\Stored Procedures\dbo.GetSp_xxxx.sql
'NULL' at line 1, column 3226
Checked in store procedure with option >>optimize line.  Now all developer gets “Errors occurred whilst parsing file†error
OPTION (OPTIMIZE FOR (@lastName = 'ZZZZZZ', @firstName = NULL, @middleName = NULL, @suffixName = NULL, @limitToAgNo = NULL))
      
      
      
      
      
      
      
      
      
        
        
        
      
     
  
'NULL' at line 1, column 3226
Checked in store procedure with option >>optimize line. Now all developer gets “Errors occurred whilst parsing file†error
OPTION (OPTIMIZE FOR (@lastName = 'ZZZZZZ', @firstName = NULL, @middleName = NULL, @suffixName = NULL, @limitToAgNo = NULL))