Database Reference
In-Depth Information
The ease of executing a single query against multiple-servers at the same time is one of my
favorite manageability features. The results that are returned with this query can be combined
into a single results pane, or in a separate results pane, which can include additional columns
for the
server
name
and the
login
that is used by the query on each server. To accomplish this
task, let us execute a query to obtain the
Product
Version
,
Product
Level
,
Edition
,
and
EngineEdition
that are registered against the Production server group.
1. In SQL Server Management Studio, on the View menu, click Registered Servers.
2. Expand a Central Management Server, right-click a server group, point to Connect,
and then click New Query.
3. In Query Editor, execute the following TSQL statement:
SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('EngineEdition') AS EngineEdition;
GO
The results are displayed as follows:
Search WWH ::
Custom Search