How to: View the Extended Events Targets for Registered Packages
SQL Server 2008 Books Online (October 2009)
How to: View the Extended Events Targets for Registered Packages

Before you create a SQL ServerExtended Events session it is useful to find out what Extended Events targets are available.

Accomplishing this task involves using Query Editor in SQL Server Management Studio to carry out the following procedure.

After the statements in this procedure finish, the Results tab of Query Editor displays the following two columns:

  • package_name
  • target_name
To view the extended events targets for registered packages

  1. In Query Editor, issue the following statements.

    use msdb
    select p.name package_name, o.name target_name
    from sys.dm_xe_objects o
    join sys.dm_xe_packages p
          on o.package_guid = p.guid
    where o.object_type = 'target' 
See Also

Concepts

SQL Server Extended Events Targets

Other Resources

sys.dm_xe_objects (Transact-SQL)
sys.dm_xe_packages (Transact-SQL)

Help and Information

Getting SQL Server 2008 Assistance
© 2009 Microsoft Corporation. All rights reserved.   Terms of Use | Trademarks | Privacy Statement
Page view tracker
Rate the Lightweight library
x
Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.
Do you like the SearchBox?
Do you like the tabbed code blocks?
How useful is this topic?
Tell us more.
Thanks
x
You're helping to improve MSDN Online.
Feedback
Switch View
Classic
Lightweight Beta
ScriptFree
Switch View