Server.Triggers Property

Represents a collection of ServerDdlTrigger objects. Each ServerDdlTrigger object represents a server data definition language (DDL) trigger that is defined on the instance of SQL Server.

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public ReadOnly Property Triggers As ServerDdlTriggerCollection

public ServerDdlTriggerCollection Triggers { get; }

public:
property ServerDdlTriggerCollection^ Triggers {
    ServerDdlTriggerCollection^ get ();
}

/** @property */
public ServerDdlTriggerCollection get_Triggers ()

public function get Triggers () : ServerDdlTriggerCollection

属性值

A ServerDdlTriggerCollection object that represents all the server DDL (data definition language) triggers that are defined on the instance of SQL Server.

备注

已更新的文本：

Server DDL triggers are procedures that run in response to data definition events at the server level. For example, you can create a server DDL trigger that runs when any database is dropped.

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Display the server DDL triggers.
Dim tr As ServerDdlTrigger
For Each tr In srv.Triggers
   Console.WriteLine(tr.Name)
Next

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

其他资源

How to: Reference an Object by Using a Collection in Visual Basic .NET
Using Collections
Setting Properties
管理服务器