SQL Server 2005 - Get Remote SQL property Server information using SQLCMD

• Posted by karthik on June 1, 2010
• 79 comments

I had a need today to get the SQL Server 2005 specs for a bunch of remote servers for upgrade/patching purposes and came across this link  with a neat little SQLCMD script! The only addition I did was to add the SERVER_NAME placeholder in it :)

A nifty little script:

---------------------------------------------------- 

:setvar defaultserver <SERVER_NAME>
:connect $(defaultserver)
USE [master]
GO
select serverproperty('productversion'),
serverproperty('productlevel'),
serverproperty('edition')
----------------------------------------------------

Ensoy!