I got the following error message regarding a SQL query I'm running in a program. SQL Server 2005 T-SQL.
Heterogeneous queries require the
ANSI_WARNINGSoptions to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. (severity 16)
Fixing it is easy, set
ON, but I wanted to know what a heterogeneous query is. A Google search brings up dozens of results telling me to set
ANSI_WARNINGS, nothing explaining what the term means. The query is:
UPDATE SRV.DB.DBO.TABLE SET Column= (SELECT Column FROM SRV1.DB.DBO.TABLE)
I'm thinking this is due to connecting to multiple database engines in one query, as I've never gotten this error otherwise.
Does "Heterogeneous" just refer to querying two different database engines in this context?