I have a sql server 2000 database which I want to import to a sql server 2008 database.
I did an import on it to the new database (which is on a separate box). But it didn't import the stored procedures.
What can I do to get the stored procedures from the 2000 to the 2008? And anything else that might be missing.
I used the Import/Export Data menu item.