Sp_server_info - TSQL Tutorial

On Transact SQL language the sp_server_info is part of Catalog Stored Procedures and return a list of attribute names and matching values for SQL Server.

Sp_server_info syntax:

sp_server_info [@attribute_id = 'attribute_id'] ;


Sp_server_info example 1:

USE model;
GO
EXEC sp_server_info
@attribute_id = '1';

Sp_server_info example 2:

USE model;
GO
EXEC sp_server_info
@attribute_id = null;