dataBase SQL 2000 To SQL 2005

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  February 10, 2006 at 4:17 am

  #365075

  Hello,

  if I  understood well, in sql 2005  :

   - if I  restore database from backup database 2000

   - or if I copy database 2005 from 2000

   - or if I detach or atach 

  my compatibility of my database is in 2000 and not 2005

  How I do for to force compatibility to 2005 ? does it exist a store procedure ?

  Thank you for your help.

   

  ---

  Kindest Regards,

  degrem_m
  Degremont

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  February 10, 2006 at 7:24 am

  #620115

  ok, I Found it,  in the propertie of my database. I change compatility to 90

  ---

  Kindest Regards,

  degrem_m
  Degremont