Convert sql 2003 to 2008

Create scripts of Stored procedure from your old DB and then run them on the new one.

There was not a version 2003 (SQL Server Versions[^]): Do you mean form 2000 or 2005 to 2008?

In any case the stored procedures should run as is: what you might consider is altering them to take advantage of any new features that might be appropriate to each procedure. Without seeing each one there is no way to tell what would be appropriate and, no, I don't want to see them.

p.s. "Please post me the reply as soon as possible" is considered rude: don't do it! People will respond as and when they can: it might be urgent to you but who else will care?

If you upload the old files to the new system, you can then resave them under the new format.
It is all automatic.

The Easiest way to convert between microsoft SQL server versions (2000,2005,2005 express,2008,2008 R2).

1. Create an Empty Microsoft Access database with no password.(MS Office 2003 works)
1. Go to import export function of the actual server.
2. Export the database to the Microsoft Access database.

3. Go to the targeted SQL server and Import the Microsoft Access Database.

This method allows you to move from one version of SQL server to another without problems.

Didier Lubo