sys-system-components-surface-area-configuration-transact-sql.md

description	sys.system_components_surface_area_configuration (Transact-SQL)
title	sys.system_components_surface_area_configuration (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	reference
f1_keywords	sys.system_components_surface_area_configuration_TSQL system_components_surface_area_configuration system_components_surface_area_configuration_TSQL sys.system_components_surface_area_configuration
dev_langs	TSQL
helpviewer_keywords	sys.system_components_surface_area_configuration catalog view
ms.assetid	d9920008-3387-4f9e-8f21-47473f2ba04f
author	WilliamDAssafMSFT
ms.author	wiassaf

sys.system_components_surface_area_configuration (Transact-SQL)

[!INCLUDE SQL Server]

Returns one row for each executable system object that can be enabled or disabled by a surface area configuration component. For more information, see Surface Area Configuration.

Column name	Data type	Description
component_name	sysname	Component name. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Cannot be NULL.
database_name	sysname	Database that contains the object. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Must be one of the following: master msdb mssqlsystemresource
schema_name	sysname	Schema that contains the object. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Cannot be NULL.
object_name	sysname	Name of the object. This will have the keyword collation, Latin1_General_CI_AS_KS_WS. Cannot be NULL.
state	tinyint	0 = Disabled 1 = Enabled
type	char(2)	Object type. Can be one of the following: P = SQL_STORED_PROCEDURE PC = CLR_STORED_PROCEDURE FN = SQL_SCALAR_FUNCTION FS = CLR_SCALAR_FUNCTION FT = CLR_TABLE_VALUED_FUNCTION IF = SQL_INLINE_TABLE_VALUED_FUNCTION TF = SQL_TABLE_VALUED_FUNCTION X = EXTENDED_STORED_PROCEDURE
type_desc	nvarchar(60)	Friendly name description of the object type.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)
sp_configure (Transact-SQL)