Where Did The Information Schama Vanished

• Gil_Adi

  SSCommitted

  Points: 1669

  More actions

  September 2, 2003 at 11:08 pm

  #160011

  I have Recently Insalled A New SQL 2000 For Testing my application

  I backed up my SQL 7 DB and retored Them On SQL Server 2000 - It went just fine.

  I am Looking for The Information schama views in the new DBs but they are not there and not int the model database.

  1. Where are they

  2. how can I restor them

  3. Do I use wrong version of SQL 2000

  4. Eny thing Else

  Thnks For Any Help

• brokenrulz

  SSCrazy

  Points: 2261

  More actions

  September 2, 2003 at 11:17 pm

  #472291

  They are under the master database.

  Pay Respect to People on your way up. For you will meet the same People on your way down.

  
  He who knows others is learned but the wise one is one who knows himself.