Database.Events Property
SQL Server 2005
Gets the events associated with the database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
'Create an event handler subroutine that runs when a table is created. Private Sub MyCreateEventHandler(ByVal sender As Object, ByVal e As ServerEventArgs) Console.WriteLine("A table has just been added to the AdventureWorks database.") End Sub 'Create an event handler subroutine that runs when a table is deleted. Private Sub MyDropEventHandler(ByVal sender As Object, ByVal e As ServerEventArgs) Console.WriteLine("A table has just been dropped from the AdventureWorks database.") End Sub Sub Main() '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") 'Create a database event set that contains the CreateTable event only. Dim databaseCreateEventSet As New DatabaseEventSet databaseCreateEventSet.CreateTable = True 'Create a server event handler and set it to the first event handler subroutine. Dim serverCreateEventHandler As ServerEventHandler serverCreateEventHandler = New ServerEventHandler(AddressOf MyCreateEventHandler) 'Subscribe to the first server event handler when a CreateTable event occurs. db.Events.SubscribeToEvents(databaseCreateEventSet, serverCreateEventHandler) 'Create a database event set that contains the DropTable event only. Dim databaseDropEventSet As New DatabaseEventSet databaseDropEventSet.DropTable = True 'Create a server event handler and set it to the second event handler subroutine. Dim serverDropEventHandler As ServerEventHandler serverDropEventHandler = New ServerEventHandler(AddressOf MyDropEventHandler) 'Subscribe to the second server event handler when a DropTable event occurs. db.Events.SubscribeToEvents(databaseDropEventSet, serverDropEventHandler) 'Start event handling. db.Events.StartEvents() 'Create a table on the database. Dim tb As Table tb = New Table(db, "Test_Table") Dim mycol1 As Column mycol1 = New Column(tb, "Name", DataType.NChar(50)) mycol1.Collation = "Latin1_General_CI_AS" mycol1.Nullable = True tb.Columns.Add(mycol1) tb.Create() 'Remove the table. tb.Drop() 'Wait until the events have occured. Dim x As Integer Dim y As Integer For x = 1 To 1000000000 y = x * 2 Next 'Stop event handling. db.Events.StopEvents() End Sub
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
