InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:13:18 GMT20http://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxThank you ! now the output is as I wanted.Mon, 03 Dec 2012 07:03:27 GMTjohnnyrmtlhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxyou just need to add an alias, sorry:[code]select * from openquery([abc],'SELECT myAlias.ServerName, DB.*, CONVERT(VARCHAR(25), DB.name) AS dbName from sys.databases DB CROSS JOIN (select name As ServerName from sys.servers where server_id =0) myAlias')[/code]Fri, 30 Nov 2012 14:49:23 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxActually i don't need @@version. need something like thisabc master 1 NULL 0x01abc tempdb 2 NULL 0x01abc model 3 NULL 0x01abc msdb 4 NULL 0x01select * 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.Fri, 30 Nov 2012 13:00:20 GMTjohnnyrmtlhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxin that case, assuming you wanted the value as columns again like your first query, it would go like this...notice i did a simple cross join, on a table we know has just one row.[code]select * from openquery([abc],'SELECT myAlias.name, myAlias.VersionInfo, DB.*, CONVERT(VARCHAR(25), DB.name) AS dbName from sys.databases DB CROSS JOIN (select name, @@version As VersionInfo from sys.servers where server_id =0) myAlias')[/code]Fri, 30 Nov 2012 12:55:36 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxI need more help with another query towards a linked server ... pardon my ignorance with the syntax :)I'm trying to merge these two queries to get the linkedserver along with all databases from it's instance.select * from openquery([abc],'SELECT *, CONVERT(VARCHAR(25), DB.name) AS dbName from sys.databases DB')and select * from openquery([abc],'select name, @@version from sys.servers where server_id =0')Fri, 30 Nov 2012 12:03:46 GMTjohnnyrmtlhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxThanks ... that's works :)I was trying to separate both queries.Wed, 28 Nov 2012 13:53:04 GMTjohnnyrmtlhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxwhy not the two values in the same query? just an oversight?[code]select * from openquery([linkedserver here],'select name, @@version from sys.servers where server_id =0')[/code]Wed, 28 Nov 2012 13:46:20 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1390052-23-1.aspxhello all,How can I merge these two queries to produce one row?i.e TESTSERVER | VERSIONselect * from openquery([linkedserver here],'select name from sys.servers where server_id =0')select * from openquery([linkedserver here],'SELECT @@version AS [VERSION]')thanks in advanceWed, 28 Nov 2012 12:15:33 GMTjohnnyrmtl