Hi ,

This doc. will give u an idea of the migration stuff and considerations.

http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf

Thanks & Rgds.

Nitin