This function can be executed as follows:

SELECT * FROM dbo.fn_getTraceColumns(3)

概要

在这篇文章中,我介绍了SQL SERVER 2000提供的非常有用的系统自定义函数,希望大家喜欢并且研究其他的系统提供的自定义函数.

下载: TRACEUDFS.SQL

参考资源:

·                       284790 INF: How to Create a SQL Server 2000 Trace

·                       283786 INF: How to Monitor SQL Server 2000 Traces

·                       270599 BUG: fn_trace_gettable Function Cannot Read Rollover Files 273972 Generated by SQL

·                       ProfilerHOW TO: Programmatically Load Trace Files into Tables

·                       268591 PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space

·                       307786 INF: Tracing to Network Drive May Reduce SQL Server Throughput

·                       286239 BUG: Replay Tool Uses LoginName Column for SETUSER Instead of DatabaseUserName Column

·

上一页  [1] [2] [3] [4] [5] [6]  下一页