It looks like we are having a problem parsing the following stored procedure:
C:\\Users\\DBachman\\AppData\\Local\\Red Gate\\SQL Source Control 0\\WorkingBases\\798f80c1-7997-4372-963e-a5827d6e0ec0\\Stored Procedures\\dbo.sproc_System_SSBQueue_Predicto_MessageReceive_Process_TopN.sql
From the information you provided:
'line 55:33: unexpected token: [";",<631>,line=55,col=33] [char=1233]'
There's a known issue about semi-colons with 2008 stored procedures, which we are currently working (internal reference number SOC-600).
But, it seems like there may be another issue because it shows that a problem actually occurs on another line:
'line 43:17: expecting "Integer", found '@N''
Could you please email the stored procedure to SqlSourceControlSupport@red-gate.com
so we can replicate your issue and make sure we can parse it correctly?