Corrupt Source File in TFS failing SQL Source Control Commit

SMiddleton

I am getting this error in 2 linked SQL databases:

---

There was an error parsing the file "C:UsersSQLDBAAppDataLocalRed GateSQL Source Control 4Transientszm34t4qv.u1sStored Proceduresdbo.DC_SP_BIL_GetPolicyTermRenewalConfigAsXML.sql" at line 16, column 7, near text ,

To resolve this issue:

1. Open the affected file.

2. Edit it to ensure the SQL is valid.

3. Commit the changes without using SQL Source Control. For example by using Tortoise SVN, or Microsoft Team Explorer.

---

I have found the file on disk and verified the SQL and compiled it without error, replaced it and checked it in via TFS.

I even started brand new and re-typed the whole thing in another script.

What else can I do?

Thanks in advance

Sergio R

Hi Steve,

I have opened a support ticket and I am going to contact you through there.

Thank you,

crimdon

I seem to get this on a regular basis. The fix is to update the SQL script in your workspace and then check it back in to TFS.

Seems to me that Source Control sometimes adds corrupted lines to the end of scripts. TFS doesn't seem to be the common link either as I've also have it happen with a local file repo.