Before making a change to a stored procedure please use the following steps to get a backup copy of the code.
In all cases, it is recommended to have a FULL backup of your DB.
1. Run SQL management Stuido > connect DB instance & Right Click DB 2. Select Tasks > Generate Scripts This launches Generate SQL Script Wizard launches.
3. Select DB & Continue to the next screen 4. Select Store Procedures 5. From the list, select the stored procedure you require a backup. 6. select Script to new query window 7. Copy the code 8. To re-create this stored procedure simply replace the line CREATE PROCEDURE [dbo].[spEXAMPLE] with ALTER PROCEDURE [dbo].[spEXAMPLE]
Rate this Article
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.