| Reply To Message: |
| Posted By |
n/a on 1/1/2001 |
| Subject: |
SQL 7.0 tracing |
| Message: |
Actually, I don't have access to a SQL Server 7.0 machine right now (much less a SQL 6.5 box) but this should all be possible using the older tracing extended stored procs. See Books Online in SQL Server 2000 for a mapping between the SQL Server 2000 commands and the 7.0 commands by searching for "Creating and Managing Traces and Templates".
Here is a sample of the mappings:
SQL 7.0 SQL 2000
----------------------------------------------------
xp_trace_geteventclassrequired fn_trace_geteventinfo
xp_trace_getqueuecreateinfo fn_trace_geteventinfo
xp_trace_getqueueproperties fn_trace_geteventinfo
xp_trace_getqueuecreateinfo fn_trace_getinfo
xp_trace_getqueuedestination fn_trace_getinfo
xp_trace_getqueueproperties fn_trace_getinfo
xp_trace_addnewqueue sp_trace_create
xp_trace_setqueuecreateinfo sp_trace_create
xp_trace_setqueuedestination sp_trace_create
xp_trace_generate_event sp_trace_generateevent
xp_trace_addnewqueue sp_trace_setevent
xp_trace_eventclassrequired sp_trace_setevent
xp_trace_seteventclassrequired sp_trace_setevent
xp_trace_destroyqueue sp_trace_setstatus
xp_trace_pausequeue sp_trace_setstatus
xp_trace_restartqueue sp_trace_setstatus
xp_trace_startconsumer sp_trace_setstatus
xp_trace_getappfilter fn_trace_getfilterinfo
xp_trace_getconnectionidfilter fn_trace_getfilterinfo
xp_trace_getcpufilter fn_trace_getfilterinfo
xp_trace_getdbIdfilter fn_trace_getfilterinfo
xp_trace_getdurationfilter fn_trace_getfilterinfo
xp_trace_geteventfilter fn_trace_getfilterinfo
xp_trace_gethostfilter fn_trace_getfilterinfo
xp_trace_gethpIdfilter fn_trace_getfilterinfo
xp_trace_getIndIdfilter fn_trace_getfilterinfo
xp_trace_getntdmfilter fn_trace_getfilterinfo
xp_trace_getntnmfilter fn_trace_getfilterinfo
xp_trace_getobjidfilter fn_trace_getfilterinfo
xp_trace_getreadfilter fn_trace_getfilterinfo
xp_trace_getserverfilter fn_trace_getfilterinfo
xp_trace_getseverityfilter fn_trace_getfilterinfo
xp_trace_getspIdfilter fn_trace_getfilterinfo
xp_trace_getsysobjectsfilter fn_trace_getfilterinfo
xp_trace_gettextfilter fn_trace_getfilterinfo
xp_trace_getuserfilter fn_trace_getfilterinfo
xp_trace_getwritefilter fn_trace_getfilterinfo
xp_trace_setappfilter sp_trace_setfilter
xp_trace_setconnectionidfilter sp_trace_setfilter
xp_trace_setcpufilter sp_trace_setfilter
xp_trace_setdbIdfilter sp_trace_setfilter
xp_trace_setdurationfilter sp_trace_setfilter
xp_trace_seteventfilter sp_trace_setfilter
xp_trace_sethostfilter sp_trace_setfilter
xp_trace_sethpIdfilter sp_trace_setfilter
xp_trace_setIndIdfilter sp_trace_setfilter
xp_trace_setntdmfilter sp_trace_setfilter
xp_trace_setntnmfilter sp_trace_setfilter
xp_trace_setobjidfilter sp_trace_setfilter
xp_trace_setreadfilter sp_trace_setfilter
xp_trace_setserverfilter sp_trace_setfilter
xp_trace_setseverityfilter sp_trace_setfilter
xp_trace_setspIdfilter sp_trace_setfilter
xp_trace_setsysobjectsfilter sp_trace_setfilter
xp_trace_settextfilter sp_trace_setfilter
xp_trace_setuserfilter sp_trace_setfilter
xp_trace_setwritefilter sp_trace_setfilter
|
|