共用方式為


Server.EnumActiveCurrentSessionTraceFlags 方法

Gets active session flags as a 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
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

請參閱

參考

Server 類別

Microsoft.SqlServer.Management.Smo 命名空間