SP_RECOMPILE, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER

Class | Methods | Properties (34) | Qualifiers (1) | Instances | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

SP_RECOMPILE properties

SP_RECOMPILE has 34 properties (8 Local, 26 Derived)

NameOriginCIMType
ApplicationNameTRC_STORED_PROCEDURES8 [String]
ClientProcessIDTRC_STORED_PROCEDURES3 [Sint32]
ComputerNameALL_EVENTS8 [String]
DatabaseIDTRC_STORED_PROCEDURES3 [Sint32]
DatabaseNameSP_RECOMPILE8 [String]
EventSequenceTRC_ALL_EVENTS20 [Sint64]
EventSubClassSP_RECOMPILE3 [Sint32]
GroupIDTRC_STORED_PROCEDURES3 [Sint32]
HostNameTRC_STORED_PROCEDURES8 [String]
IntegerData2SP_RECOMPILE3 [Sint32]
IsSystemTRC_STORED_PROCEDURES3 [Sint32]
LineNumberSP_RECOMPILE3 [Sint32]
LoginNameTRC_STORED_PROCEDURES8 [String]
LoginSidTRC_STORED_PROCEDURES17 [Uint8]
NestLevelSP_RECOMPILE3 [Sint32]
NTDomainNameTRC_STORED_PROCEDURES8 [String]
NTUserNameTRC_STORED_PROCEDURES8 [String]
ObjectIDTRC_STORED_PROCEDURES3 [Sint32]
ObjectNameSP_RECOMPILE8 [String]
ObjectTypeTRC_STORED_PROCEDURES3 [Sint32]
OffsetSP_RECOMPILE3 [Sint32]
PostTimeALL_EVENTS101 [DateTime]
RequestIDTRC_STORED_PROCEDURES3 [Sint32]
SECURITY_DESCRIPTOR__Event17 [uint8]
ServerNameTRC_STORED_PROCEDURES8 [String]
SessionLoginNameTRC_ALL_EVENTS8 [String]
SPIDALL_EVENTS3 [Sint32]
SqlHandleSP_RECOMPILE17 [Uint8]
SQLInstanceALL_EVENTS8 [String]
StartTimeTRC_ALL_EVENTS101 [DateTime]
TextDataTRC_STORED_PROCEDURES8 [String]
TIME_CREATED__Event21 [uint64]
TransactionIDTRC_STORED_PROCEDURES20 [Sint64]
XactSequenceTRC_STORED_PROCEDURES20 [Sint64]

Detailed description of SP_RECOMPILE properties

Local properties (8) of SP_RECOMPILE class

DatabaseName property
CIMTYPE'String'
DatabaseName property is in 287 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 4 namespaces
EventSubClass property
CIMTYPE'Sint32'
EventSubClass property is in 55 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
IntegerData2 property
CIMTYPE'Sint32'
IntegerData2 property is in 8 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
LineNumber property
CIMTYPE'Sint32'
LineNumber property is in 20 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 3 namespaces
NestLevel property
CIMTYPE'Sint32'
NestLevel property is in 39 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
ObjectName property
CIMTYPE'String'
ObjectName property is in 280 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 5 namespaces
SqlHandle property
CIMTYPE'Uint8'
SqlHandle property is in 5 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace

Derived properties (26) of SP_RECOMPILE class

ApplicationName property
CIMTYPE'String'
ApplicationName property is in 98 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 3 namespaces
ClientProcessID property
CIMTYPE'Sint32'
ClientProcessID property is in 85 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
ComputerName property
CIMTYPE'String'
ComputerName property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 11 namespaces
DatabaseID property
CIMTYPE'Sint32'
DatabaseID property is in 107 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
EventSequence property
CIMTYPE'Sint64'
EventSequence property is in 118 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
LoginName property
CIMTYPE'String'
LoginName property is in 363 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
LoginSid property
CIMTYPE'Uint8'
LoginSid property is in 103 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
NTDomainName property
CIMTYPE'String'
NTDomainName property is in 98 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
NTUserName property
CIMTYPE'String'
NTUserName property is in 91 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
ObjectType property
CIMTYPE'Sint32'
ObjectType property is in 299 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 6 namespaces
PostTime property
CIMTYPE'DateTime'
PostTime property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
RequestID property
CIMTYPE'Sint32'
RequestID property is in 96 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 4 namespaces
SECURITY_DESCRIPTOR property
CIMTYPE'uint8'
SECURITY_DESCRIPTOR property is in 407 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 142 namespaces
ServerName property
CIMTYPE'String'
ServerName property is in 91 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 23 namespaces
SessionLoginName property
CIMTYPE'String'
SessionLoginName property is in 118 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
SPID property
CIMTYPE'Sint32'
SPID property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
SQLInstance property
CIMTYPE'String'
SQLInstance property is in 385 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
StartTime property
CIMTYPE'DateTime'
StartTime property is in 118 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 24 namespaces
TextData property
CIMTYPE'String'
TextData property is in 85 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace
TIME_CREATED property
CIMTYPE'uint64'
TIME_CREATED property is in 409 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 142 namespaces
TransactionID property
CIMTYPE'Sint64'
TransactionID property is in 93 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 2 namespaces
XactSequence property
CIMTYPE'Sint64'
XactSequence property is in 64 classes of ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER and in 1 namespace

SP_RECOMPILE Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
abstractTrue

SP_RECOMPILE System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:SP_RECOMPILE'___SYSTEM8
__NAMESPACE'ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['TRC_STORED_PROCEDURES', 'TRC_ALL_EVENTS', 'ALL_EVENTS', '__ExtrinsicEvent', '__Event', '__IndicationRelated', '__SystemClass']___SYSTEM8
__PROPERTY_COUNT34___SYSTEM3
__RELPATH'SP_RECOMPILE'___SYSTEM8
__DYNASTY'__SystemClass'___SYSTEM8
__SUPERCLASS'TRC_STORED_PROCEDURES'___SYSTEM8
__CLASS'SP_RECOMPILE'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to SP_RECOMPILE

Number of classes:1
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
SQL_STMTRECOMPILE0340---
WUtils.com
online utility - toplist