SQ xtype

• sql_novice_2007

  Hall of Fame

  Points: 3307

  More actions

  March 20, 2012 at 12:50 pm

  #252974

  In the database I am working in, when I run the query select * FROM sysobjects I found two objects with xtype SQ which is service queue.

  I need to generate the script for this object. But where can I find this object in the database engine to create the script?

  Thanks.

• Jared

  SSC Guru

  Points: 61793

  More actions

  March 20, 2012 at 1:36 pm

  #1461860

  I'm not sure what you are looking for exactly, or why. However, I don't believe there is a place to simply generate a script for the queue object in SSMS.

  Jared
  CE - Microsoft