Query to verify database SINGLE USER on SQL 2000

• gdraghetti

  SSC Eights!

  Points: 977

  More actions

  June 1, 2010 at 10:18 am

  #219538

  Hi,

  Which query I write to verify if a database is SINGLE USER on Microsoft SQL 2000 ?

  Thank you and best regards

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  June 1, 2010 at 12:13 pm

  #1174956

  select databaseproperty('databasename','issingleuser')

  Greg

• gdraghetti

  SSC Eights!

  Points: 977

  More actions

  June 3, 2010 at 6:06 am

  #1175869

  It's works fine ! Thank you Greg