Здравствуйте, andrey_mp, Вы писали:

_>Добрый денб всем.

_>Как получить список серверов — понятно.
_>А вот как получить версию сервера имея только его имя ?

_>нашел ссылку —
_>http://www.rsdn.ru/Forum/?mid=1134145

Автор: Chupa_Kabra
Дата: 20.04.05

_>написано что можно с помощью broadcast метода, это как ?
_>а если сервер слушает по NamedPipe ?

Ну вот так можно о моем сервере получить инфу:

0 Apr 27 2007 5:41PM 0 Cyrillic_General_CI_AS 1
0 DEVSTATION 0 No 2
0 9.00.3042.00 0 Yes 3
0 Developer Edition 0 No 4
0 13876 0 No 5
0 1 0 1 6

exec sp_executesql @stmt=N'begin try
declare @jobcount bigint;
declare @processorcount int;
use msdb;
select @jobcount = count(distinct job_id) from sysjobs;

use master;
Select  @processorcount = count(*) from sys.dm_os_schedulers where is_online = 1 and scheduler_id < 255

select 0 as error_no
,       convert(nvarchar,login_time) as value_col1
,       0 as error_state
,       convert(sysname, serverproperty(''collation'')) as value_col2
,       1 as pos 
from sys.sysprocesses where spid=1
union
select 0 as error_no
,       @@servername as value_col1
,       0 as error_state
,       case when convert(sysname, serverproperty(''IsClustered'')) = ''0'' then ''No'' else ''Yes'' end as value_col2
,       2 as pos
union 
select 0 as error_no
,       convert(sysname, serverproperty(''ProductVersion'')) as value_col1
,       0 as error_state
,       case when convert(sysname,serverproperty(''IsFullTextInstalled'')) = ''0'' then ''No'' else ''Yes'' end as value_col2
,       3 as pos
union
select 0 as error_no
,       convert(sysname, serverproperty(''edition'')) as value_col1
,       0 as error_state
,       case when convert(sysname,serverproperty(''IsIntegratedSecurityOnly'')) = ''0'' then ''No'' else ''Yes'' end  as value_col2
,       4 as pos
union
select 0 as error_no
,       convert(sysname, serverproperty(''ProcessID'')) as value_col1 
,       0 as error_state
,       case when value = 1 then ''Yes'' else ''No'' end as value_col2
,       5 as pos 
from sys.sysconfigures where config = 1548
union 
select 0 as error_no
,       convert (nvarchar(20),@jobcount) as value_col1
,       0 as error_state
,       convert (nvarchar(20),@processorcount) as value_col2 
,       6 as pos
order by pos
end try
begin catch
select ERROR_NUMBER() as error_no
,       ERROR_SEVERITY() as value_col1
,       ERROR_STATE() as error_state
,       ERROR_MESSAGE() as value_col2 
,       -100 as pos
end catch',@params=N''

Вообщем там мусора много некогда выбирать но показывает по-мойму то, что надо!
Не знаю как 2000 будет работать!!!