sys.system_components_surface_area_configuration (Transact-SQL)
Returns one row for each executable system object that can be enabled or disabled by a surface area configuration component. For more information, see Understanding 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
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.