How can we help you today? How can we help you today?

Get Latest / Commit changes error

I have been able to add a number of databases to red-gate sql source control but I am having problems with one DB in particular, 2 stored procedures that throw the error below unless I comment out the entire stored proc contents.

There was an error parsing the file "..." at line 12, column 7, near the text .

To resolve this issue:
1. ...
2. ...
3. ...

The stored procedures are similar in nature:

BEGIN
create temp table

select [..]
into #ttable
from openquery (..)
MERGE [..]
USING [..]
WHEN NOT MATCHED BY TARGET THEN
INSERT (..)
VALUES (..)
WHEN MATCHED THEN UPDATE
SET [..]

END
jgagnon
0

Comments

3 comments

Sort by
  • Allen LeVan
    Hello,

    Sorry for the problem you're having with SQL Source Control. We've opened a ticket so we can further troubleshoot this issue with you. I'll be reaching out to you through that ticket shortly, thanks.
    Allen LeVan
    0
  • markoos99
    Hi Allen,

    Was this issue ever resolved? I have the exact same problem, given the exact same pattern of code in the stored proc. I've updated to the latest 4.2.2.186, but still the same.

    Thanks
    -Mark
    markoos99
    0
  • markoos99
    Hi Allen,

    Was this issue ever fixed for this user? I'm having the exact same problem and have the exact same pattern in my stored procedure.

    Thanks
    -Mark
    markoos99
    0

Add comment

Please sign in to leave a comment.