Converfting a 2000 db to 2005.

I have a 2000 db that I've restored to a 2005 machine. When it restored it
restored as a version 80 db (2000 I would assume). To convert it to 2005 do
I just go into options and change the compatibility to 90?
Will it tell me if there are things that can't be converted?
TIA - Jeff.
It actually upgraded it to 2005 when you restored it. But upgraded dbs are
kept in 80 (2000) computability mode by default. Just change it to 9.0 and
you are all set.
Andrew J. Kelly SQL MVP
"Mufasa" <jb@.nowhere.com> wrote in message
news:ObOhzGicHHA.588@.TK2MSFTNGP06.phx.gbl...
>I have a 2000 db that I've restored to a 2005 machine. When it restored it
>restored as a version 80 db (2000 I would assume). To convert it to 2005 do
>I just go into options and change the compatibility to 90?
> Will it tell me if there are things that can't be converted?
> TIA - Jeff.
>