Use SQLCMD for this....
In MS Management Stusio(SSMS), you will find SQLCMD Mode under the Query menu....
Use the following script -
:setvar defaultserver
:connect $(defaultserver)
USE [master]
GO
select serverproperty('productversion'),
serverproperty('productlevel'),
serverproperty('edition')
Just change the server name and execute.....hope this helps!
Note: The windows login needs to have administrative privileges on all the servers......also if you have multiple instances use ....for example SON1843\sql
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.