Error when finding changes to commit for prev. linked DB

[dbachman]

Microsoft SQL Server 2008 (SP1) - 10.0.2723.0 (Intel X86) Jul 10 2009 01:41:08 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

Connecting with windows authentication.

Failed to update:
#oEc.#8Jf: Errors occured whilst parsing file 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
'line 43:17: expecting "Integer", found '@N''
'line 55:33: unexpected token: [";",<631>,line=55,col=33] [char=1233]'
---> cZ: Errors occured whilst parsing file 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
'line 43:17: expecting "Integer", found '@N''
'line 55:33: unexpected token: [";",<631>,line=55,col=33] [char=1233]'
---> line 43:17: expecting "Integer", found '@N'
--- End of inner exception stack trace ---
at #oEc.#7Jf.#t.#B3.#sKf()
at #oEc.#7Jf.#gKf(Action action)
--- End of inner exception stack trace ---

Server stack trace:
at #eEc.#fEc.#t.#izb.#j5f()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)

[sherr]

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?

Thank you!