Missing database devices in master.dbo.sysdevices

• lahteenj

  SSC Enthusiast

  Points: 180

  More actions

  June 2, 2008 at 12:44 am

  #121636

  Hi

  I just found a database that is working ok but when i run sp_helpdevice *device name*

  I get just and error. When i took a look at the sysdevices table in master there are no entries for this database there.

  Any suggestions how to fix this, does any database checks fix this?

  SQL server is an sql 2000 version 8.00.2039 (SP4)

  Regards

  Jari

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  June 2, 2008 at 8:09 pm

  #823374

  I think you want sysfiles.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question