I'm using SQL Server 2008, and I would like to copy stored procedures from one database to another. How?
Sql-server – Move stored procedures from one database to another in SQL Server
scriptingsql server
Related Topic
- Sql-server – How to remove a specific bad plan from the SQL Server query cache
- Sql-server – Transferring databases from SQL Server 2008 to SQL Server 2005
- SQL Server – How to Dump Database to SQL Script
- Sql-server – Running a MS-SQL Server Stored Procedure from MS Access
- SQL Server 2008 – How to Copy Instance to Another Server
- Security – Configure user login and stored procedures permissions on SQL Server
- Sql-server – Activity Monitor not showing stored procedures
Best Answer
Right click on the SP under the DB and click Script Stored Procedure As > CREATE To > File, it will create an SQL script file, then run that script on the other database.