Migrating to 2005

Im trying to move from a 2000 server to 2005 server. However when I try to d
o
the import there is no option for selecting UDF's or stored procedures, just
tables and views...is there a way to get these over?..thanks
-JimI would detach the database(s) and then attach it on the 2005 instance, or
use backup/restore unless you have a specific reason for
exporting/importing.
See the Books Online topic "How to: Upgrade a Database Using Detach and
Attach (Transact-SQL) " for more info if you need it.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:693C6609-EA67-4130-8EF8-024FD5318AAC@.microsoft.com...
> Im trying to move from a 2000 server to 2005 server. However when I try to
> do
> the import there is no option for selecting UDF's or stored procedures,
> just
> tables and views...is there a way to get these over?..thanks
> -Jim