Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Server.EnumActiveCurrentSessionTraceFlags Method

Gets active session flags as a DataTable.

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

Return Value

Type: System.Data.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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.