Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET.

• amanmeet.mehta 46966

  SSC Eights!

  Points: 859

  More actions

  June 6, 2011 at 4:15 pm

  #251300

  We have recently migrated from SQL Server 2000 to SQL Server 2008. In the existing store Procedure when opening an xml using OPENXML one column was defined twice and was working on 2000. However when we compile the same SP on 2008, the system gives me an error " Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET."

  I am not sure why this is coming in 2008, the last I want to do is change the existing working code.

  Please let me know in case you have any solutions.

  Thanks,

  Aman

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 7, 2011 at 9:40 am

  #1335104

  Duplicate post, reply here: http://www.sqlservercentral.com/Forums/Topic1121034-391-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato