How to get queue handle by queue name

Hi
I have a trace in SQL Server 7 that starts with the server start up. I know
the queue definition name, but i don't the queue_handle.
I need the queue_handle to stop the trace if required in between.
Thanks in advance.
Pushkar
Pushkar wrote:
> Hi
> I have a trace in SQL Server 7 that starts with the server start up.
> I know the queue definition name, but i don't the queue_handle.
> I need the queue_handle to stop the trace if required in between.
> Thanks in advance.
> Pushkar
xp_trace_enumqueuehandles - to enum queue handles
xp_trace_enumqueuedefname
xp_trace_getqueueautostart
xp_trace_getqueuedestination - or any of the get* functions to return
info about the queue
David Gugick
Quest Software
www.imceda.com
www.quest.com