Поделиться через


Метод EnumActiveCurrentSessionTraceFlags

Возвращает активные флаги сеанса в виде DataTable.

Пространство имен:  Microsoft.SqlServer.Management.Smo
Сборка:  Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
Public Function EnumActiveCurrentSessionTraceFlags As DataTable
'Применение
Dim instance As Server
Dim returnValue As DataTable

returnValue = instance.EnumActiveCurrentSessionTraceFlags()
public DataTable EnumActiveCurrentSessionTraceFlags()
public:
DataTable^ EnumActiveCurrentSessionTraceFlags()
member EnumActiveCurrentSessionTraceFlags : unit -> DataTable 
public function EnumActiveCurrentSessionTraceFlags() : DataTable

Возвращаемое значение

Тип: System.Data. . :: . .DataTable
Объект типа DataTable, представляющий одну таблицу данных в памяти.

Замечания

The following sample shows how to use this feature in C#:

// compile with: /r:Microsoft.SqlServer.Smo.dll /r:Microsoft.SqlServer.Management.Sdk.Sfc.dll /r:Microsoft.SqlServer.ConnectionInfo.dll /r:System.Data.dll

using System;
using System.Data;
using System.Text;
using Microsoft.SqlServer.Management.Smo;


public class A {
   public static void Main() {
      Server svr = new Server();

      // Turning on a trace flag
      svr.Databases["master"].ExecuteNonQuery("DBCC TRACEON (3205,-1)");

      // enumeratiung through the active trace flags in the current session
      DataTable dt = svr.EnumActiveCurrentSessionTraceFlags();

      // Reading the datatable returned
      Console.WriteLine("ROWCOUNT = " + dt.Rows.Count);


      foreach (DataRow row in dt.Rows) {
         StringBuilder record = new StringBuilder();
         foreach (DataColumn col in dt.Columns) {
            record.Append(col.ColumnName + "=" + row[col.ColumnName] + "  ");
         }
         Console.WriteLine(record);
      }
   }
}

The following sample shows how to use this feature in Visual Basic:

' compile with: /r:Microsoft.SqlServer.Smo.dll /r:Microsoft.SqlServer.Management.Sdk.Sfc.dll /r:Microsoft.SqlServer.ConnectionInfo.dll /r:System.Data.dll
Imports System.Data
Imports System.Text
Imports Microsoft.SqlServer.Management.Smo

Public Class A
   Public Shared Sub Main()
      Dim svr As New Server()

      ' Turning on a trace flag
      svr.Databases("master").ExecuteNonQuery("DBCC TRACEON (3205,-1)")

      ' enumeratiung through the active trace flags in the current session
      Dim dt As DataTable = svr.EnumActiveCurrentSessionTraceFlags()

      ' Reading the datatable returned
      Console.WriteLine("ROWCOUNT = " & dt.Rows.Count)


      For Each row As DataRow In dt.Rows
         Dim record As New StringBuilder()
         For Each col As DataColumn In dt.Columns
            record.Append(col.ColumnName & "=" & Convert.ToString(row(col.ColumnName)) & "  ")
         Next
         Console.WriteLine(record)
      Next
   End Sub
End Class