checking in complaining about stored procs not compiling

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

checking in complaining about stored procs not compiling

Postby ChrisAdkin » Thu Dec 23, 2010 5:19 pm

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.
ChrisAdkin
 
Posts: 1
Joined: Thu Dec 23, 2010 4:21 pm
Location: Nottingham

Postby peter.peart » Mon Dec 27, 2010 1:30 pm

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
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests