Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Property ValueA UserDefinedAggregateCollection object that represents all the user-defined aggregates defined on the database.
Updated text: 17 July 2006
Specific user defined aggregates can be referenced by using this collection by specifying the name of the user defined aggregate. To add a new user defined aggregate to the collection, call the user defined aggregate constructor, UserDefinedAggregate.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Reference the AdventureWorks database. Dim db As Database db = srv.Databases("AdventureWorks") 'Display all the triggers in the database. Dim tr As DatabaseDdlTrigger For Each tr In db.Triggers Console.WriteLine(tr.Name) Next