checking in complaining about stored procs not compiling

ChrisAdkin

I'm using source control 1.1.0.19, with SQL Server 2008 R2 and sub version. When I try to check in, Red Gate source control is complaining that a perfectly good stored proc which I have already checking via a different sub version client will not compile, this is what I'm getting:-

Errors occurred whilst parsing file C:\Users\chris\AppData\Local\Red Gate\SQL Source Control 1\WorkingBases\onys2ojg.axm\Stored Procedures\process_stream_1.up_dq_click_through.sql
'line 1:2959: expecting "Integer", found '@v_ct_batch_size''
'line 1:3288: expecting "end", found ';''
'line 1:10765: expecting "try", found ';''
'line 1:10765: expecting "end", found ';''
'line 1:10778: expecting "conversation", found 'TRY''
'CATCH' at line 1, column 10812
'CATCH' at line 1, column 11400
';' at line 1, column 11401
'line 1:11407: expecting "conversation", found ';''

Can someone point me in the correct direction as to resolving this issue.

peter.peart

Hi there,

Thanks for your post. It sounds like your working base may be a bit messed up. If the sproc is already checked into SVN, you can try unlinking and relinking the DB to SQL Source Control.

Alternatively, you can use SQL Compare PRO to perform a comparison against what exists in the live DB against the working base folder location, i.e. C:\Users\chris\AppData\Local\Red Gate\SQL Source Control 1\WorkingBases\onys2ojg.axm and see where the differences are in the sproc, and also against SVN assuming it is in there in the first place.

HTH!

Pete