Share via


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.

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.

See Also

Reference

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

Other Resources

Surface Area Configuration

Help and Information

Getting SQL Server 2005 Assistance