Copying a SQL Server stored procedure with a query
I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 19, 2008 8:11 PM
UPDATED:
June 19, 2008 9:43 PM
RELATED QUESTIONS
- How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
- Create Excel file on web server by using SQL
- How can I call a trigger in a SQL Server stored procedure?
- Moving SQL Stored Procedures
- Toggling a case sensitive query in SQL Server 2005
Answer Wiki:
You can use the procedure sp_helptext to query for the code which created the procedure.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.