Home Forums Programming General Syntax request needed. Merge an 'openquery' select towards linkedserver RE: Syntax request needed. Merge an 'openquery' select towards linkedserver

  • Actually i don't need @@version. need something like this

    abc master1NULL0x01

    abc tempdb2NULL0x01

    abc model3NULL0x01

    abc msdb4NULL0x01

    select * from openquery([abc],'SELECT *, CONVERT(VARCHAR(25), DB.name) AS dbName from sys.databases DB')

    and

    select * from openquery([abc],'select name from sys.servers where server_id =0')

    getting this error

    Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "name" is a duplicate.