Without flailing through a file search, how does one track down the code that caused an error during SSDT publish preview?

Normally any errors come later such that the statement can be traced in the publish preview, but when the error comes in the preview I see no clear way to find what caused it.

I manually tracked it down this time (to a valid statement!): View Preview unclickable (The error about I.RowNum is the same thing)

Update: The faulty code was in a stored procedure already existing on the server. Even though I removed it from my database project it still failed the publish preview, so I had to delete it from the server to make the publish work. So a file search didn't even work to find the code it flagged.

Update 2: The error isn't actually failing the publish preview (at least by itself), it is just shown only when the step fails (I have since seen it appear again). The actual error is still unknown as the only other messages were data loss warnings that the advanced settings were set to allow. I am now confused more than ever.

Probably related: Update to SSDT started throwing ambiguous column name errors on valid SQL

Also related: Unaliased ORDER BY columns.

So I'm guessing this is actually a bug in SSDT at this point. Can anybody confirm? I'd still like to know how to track down the buggy code when it is on the server and fails the publish preview.


  • The build always succeeds, whether I clean first, or just rebuild. – Elaskanator May 18 '18 at 18:25
  • There are no database references, and unfortunately I cannot share the publish XML because I can't reveal our software at all. – Elaskanator May 18 '18 at 18:42
  • I removed the only reference I found searching for "CE.RowNum" and manually deleted the bin and obj folders, cleaned, and rebuilt the project. It still fails with the same error when publishing. Add on top of that, the query with that "CE.RowNum" reference is valid as far as I can tell! – Elaskanator May 18 '18 at 19:16
  • I restarted VS and it is still failing the same. Not a single file contains the string "CE.RowNum" – Elaskanator May 18 '18 at 20:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.