The column prefix 'DT-1' does not match with a table name or alias name used in the query

ChrisRoy

I've been getting a random error when comparing 2 database using SQL Data Compare v15 from the command line. I'm simply testing locally on my laptop, this is normally executed on our server (where I've never seen this error happened since we've been using RedGate SQL Data Compare 10 years ago). So this could be an issue that's localized to my laptop installation and/or my local SQL Server instance.

Once in a while, i get the following error code returned by SQL Data Compare: 126

and the error message in the command prompt is

Error: The column prefix 'DT-1' does not match with a table name or alias name used in the query. The column prefix 'DT-1' does not match with a table name or alias name used in the query.

I've tried to profile all the database calls happening on both databases while the comparison is happening. But I'm not catching anything that has the text "DT-1"

Oddly enough, I've seen the same error sometimes giving the exact same error message, but instead using 'DT-3' instead of 'DT-1', which makes me think this is some sort of auto-generated SQL code RedGate is creating and trying to execute. I just don't know why i can't trace it in the profiler.

Maybe someone at RedGate will know what this could be cause by.

Thanks for the help

JoshH

I would take a look at this article. The person was getting the same error when querying from their local machine to a remote server.