how know the MAX_QUEUE_READERS value of a queue

• gdraghetti

  SSC Eights!

  Points: 977

  More actions

  December 27, 2011 at 6:44 am

  #248273

  Hi,

  Which queries I have to write to know the value of MAX_QUEUE_READERS setted on a existing queue ?

  Thanks

• gdraghetti

  SSC Eights!

  Points: 977

  More actions

  December 27, 2011 at 7:10 am

  #1425680

  Resolved!

  USE TestDB

  select * from sys.service_queues