RE: Select version from linked server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 08:47:08 -0800

Not nerar one of our linked servers now, but have you tried:

insert into dbname..table select * from openquery(SERVERNAME, 'select
@@version')

Regards
Mike

"CC&JM" wrote:

> Hello,
>
> I´m trying to get the MSSQL Server version of my DBServers, i´ve created one
> script where's created one linked server and then i try to query with the
> openquery that server @@version.
>
> /*Statement used to get @@version*/
> --create linkedserver and linkedserverlogin
> ..
> insert into dbname..table select @@version from openquery(SERVERNAME,
> 'insert into dbname..table select @@version')
> ..
> --drop linkedserverlogin and linkedserver
>
> Any idea?
>
> Thanks and best regards
>
>
>

Relevant Pages

  • Re: Linked Server setups
    ... Deepak wrote: ... This will give you all the details you want about the linked servers. ... > Tom. ...
    (microsoft.public.sqlserver.programming)
  • RE: Linked Server setups
    ... Execute sp_linkedservers. ... This will give you all the details you want about the linked servers. ... Regards ... Deepak ...
    (microsoft.public.sqlserver.programming)