This topic has not yet been rated - Rate this topic

NSSnapshotEvents (Transact-SQL)

SQL Server 2005

Produces the events snapshot report for an instance of Microsoft SQL Server Notification Services. You can use this report to determine how long it has been since an event class has received events from an event provider.

Syntax


[ schema_name . ] NSSnapshotEvents

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column Name	Data Type	Description
ApplicationName	nvarchar(255)	Name of an application.
ApplicationActivationState	nvarchar(255)	Activation state for the application. The state can be enabled or disabled.
EventActivationState	nvarchar(255)	Activation state for events in the application. This value indicates whether events can be submitted programmatically, not event provider activation state. The value can be enabled or disabled.
EventClassName	nvarchar(255)	Name of an event class within the application.
LastTimeEventBatchCollected	datetime	Date and time at which the last event batch was collected for the event class.
SecondsSinceEventBatchCollected	int	Elapsed time, in seconds, since the last event class was collected for the event class.
LastEventBatchEventCount	bigint	Number of events collected in the last event batch for the event class.
LastEventBatchProvider	nvarchar(255)	Name of the event provider that submitted the last event batch for the event class. This value is NULL if the events were directly inserted into the <EventClassName> view.

Remarks

Notification Services creates the NSSnapshotEvents stored procedure in the instance database when you create the instance. When you update the instance, Notification Services recompiles the stored procedure.

This stored procedure is in the instance schema, which is specified by the SchemaName element of the instance configuration file (ICF). If no schema name is provided, the default schema is dbo.

The result set is ordered by the ApplicationName value, and then by the EventClassName value.

Permissions

Execute permissions default to members of the NSAnalysis database role, db_owner fixed database role, and sysadmin fixed server role.

Examples

The following example produces the events snapshot report for all applications hosted by an instance. The instance uses the default database settings, which places all instance objects in the dbo schema.

EXEC dbo.NSSnapshotEvents;

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

NSSnapshotEvents (Transact-SQL)

Reference

Other Resources

Help and Information

Community Additions