Link to home
Start Free TrialLog in
Avatar of dddon123
dddon123

asked on

Import Stored Procedures from Sql 2000 to 2005

I'm new to Sql 2005 and was wondering if someone could give me quick instructions on how to import some stored procedures from a Sql 2000 database into a Sql 2005 database. The Import Data function at the Sql 2005 database level only seems to allow for tables to be imported.

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can generate the script for the sps and run it on the SQL server 2005