dataBase SQL 2000 To SQL 2005

  • 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

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


    Kindest Regards,

    degrem_m
    Degremont

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply