I have tested this on SQL7 SP2 and the diagrams do not appear in the target database, though the target dtproperties has been correctly populated.

Should you need to...

Hi,

Each time the alert fires to say the emergency login is logged in I run the below statements:-

*******************************************

EXEC xp_trace_addnewqueue 1000, 5, 95, 90, @column_value, @queue_handle OUTPUT

EXEC xp_trace_seteventclassrequired @queue_handle, 12,...

Hi,

Is there some reason as to why when I use the xp_trace_addnewqueue stored proc set to show all columns (as below) it will not display the text column.

EXEC...

Sorry I had meant xp_sqltrace not xp_trace. In 7.0 is says somnething about this being phased out and to use the xp_trace procs.

So where a trace flag is not available...

Thanks for this, I will try and set-up auditing using the extended profiler stored procs.(xp_trace_addnewqueue and such like)

Can anybody tell me what are the core differences with respect to the...

Thanks for the help Guys.

Just one more question, I'm using SQL Server 7.0, is it possible to save a Trace profile created using the profiler and then being able to...

Stephen,

Thanks for the tips. I hope you could help me clarify a few related queries.

Is there any way I ensure that the trace triggered does not run...