Home Forums SQL Server 2005 Administering Remote SQL Version Query Problem RE: Remote SQL Version Query Problem
dbaker-620086
SSCrazy
Points: 2336
More actions
June 19, 2008 at 7:58 am
#831115
moderately clunky, but this might do
declare @remver sql_variant
select @remver=REMVER from OPENQUERY(a_linked_server,'select REMVER=serverproperty(''productversion'')')
select @remver
although many better ways with SMO, ADO.NET etc
HTH
Dick