Hi all!

I have recently upgraded from SQL 2000 to SQL 2005.

I have a live database hosted by a third party which is SQL 2000, and I want to import the data into a new db in my local SQL 2005.

I can successfully get the tables but I cant get the stored procedures.

Can anyone point me in the right direction on this - I can request a .bak from the hosts if this will work???

Thanks in advance