Default database changed by itself

• ruchika thapa

  Ten Centuries

  Points: 1356

  More actions

  July 7, 2008 at 11:29 am

  #123080

  i created 9 new database in production server and one login for these database.

  But default database for other old logins changed to these new database by itself.

  I am using sql server 2000 sp3.

• nary

  SSCrazy

  Points: 2869

  More actions

  July 7, 2008 at 11:42 am

  #839065

  How did you created databases , using script or from EM .

• ruchika thapa

  Ten Centuries

  Points: 1356

  More actions

  July 7, 2008 at 12:16 pm

  #839088

  yes i created database using EM.

• kevin.kunz

  SSChasing Mays

  Points: 635

  More actions

  July 7, 2008 at 12:45 pm

  #839106

  Default was based off of the model then.