Get Latest / Commit changes error
jgagnon
Posts: 2
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
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
Comments
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.
Red Gate Software
US Product Support
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
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