¿Le resultó útil esta página?
¿Tiene comentarios adicionales?
Caracteres restantes: 1500
Exportar (0) Imprimir
Expandir todo
Este contenido no se encuentra disponible en su idioma, pero aquí tiene la versión en inglés.

Get the Configurable Parameters for the ADD TARGET Argument

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Accomplishing this task involves using Query Editor in SQL Server Management Studio.

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

  • package_name

  • target_name

  • parameter_name

  • parameter_type

  • required

Before you create a SQL Server Extended Events session, it is useful to find out what parameters you can set when you use the ADD TARGET argument in CREATE EVENT SESSION or ALTER EVENT SESSION.

To get the configurable parameters for the ADD TARGET argument using Query Editor

  • In Query Editor, issue the following statements.

    SELECT p.name package_name, o.name target_name, c.name parameter_name, 
    c.type_name parameter_type, CASE c.capabilities_desc WHEN 'mandatory' THEN 'yes' ELSE 'no' END 
    FROM sys.dm_xe_objects o JOIN sys.dm_xe_packages p ON o.package_guid = p.guid 
    JOIN sys.dm_xe_object_columns c ON o.name = c.object_name AND c.column_type = 'customizable'
    WHERE o.object_type = 'target' 
    ORDER BY package_name, target_name, required DESC
¿Te ha resultado útil?
(Caracteres restantes: 1500)
Gracias por sus comentarios

Adiciones de comunidad

© 2015 Microsoft