Export (0) Print
Expand All

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 Surface Area Configuration.

Applies to: SQL Server (SQL Server 2008 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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft