| title | sys.system_components_surface_area_configuration (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | d9920008-3387-4f9e-8f21-47473f2ba04f | ||||
| caps.latest.revision | 16 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
| 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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)
sp_configure (Transact-SQL)