sql - Duplicate column name... but only if database is case insensitive -
i'm trying query view on database has case sensitive collation linked server connection. else note view i'm trying query wrapper 3 indexed views. the error i'm getting is: duplicate column names not allowed in result sets obtained through openquery , openrowset. column name "extprice" duplicate. in view have extprice extprice . when query view server directly, don't have issues... when try use query via linked server, above error. is collation issue? how use view via linked server , still have query understand view case sensitive? i apologize in advance if stupid question. yes, result of case-sensitive collation on server views located. and it's why grouse having case-sensitive collations @ server level directly (instead of using collations @ column-level) pointed out here: http://www.sqlmag.com/blog/practical-sql-server-45/tsql/collation-sql-server-139576 only, in trying wrap brain around how you'd cram collate c...