Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Server.EnumActiveCurrentSessionTraceFlags Method

Gets active session flags as a DataTable.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

member EnumActiveCurrentSessionTraceFlags : unit -> DataTable

Return Value

Type: DataTable
An object of type DataTable representing one table of in-memory data.

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

Community Additions

Show:
© 2015 Microsoft