How to copy store procedure from SQL 2000 to 2005?

I'm using MS SQL Server Management Studio. How do copy my store procedures that are on the SQL Server 2000 to SQL Server 2005? What are my options? I don't have admin rights...only rights to my database.you can script the procedures in sql 2000 and run the script in sql 2005 for the procs to be created..............but i believe you need to have sysadmin privilege...........|||

You can read the definition from

SELECT Routine_definition
FROM INFORMATION_SCHEMA.Routines
Where Routine_Name = 'YourProcedureName'

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Expanding on Jens' comments:

Since the INFORMATION_SCHEMA views are accessible by 'Public', you may read the procedure definitions, and then you can copy and paste into a new query window for the SQL 2005 server, and after you execute the code, the procedure will be saved in the SQL 2005 server.

|||

Now, this is one procedure at a time, correct?

Thanks!

|||

That's correct.

If you had admin rights, then there are much easier methods.