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]
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.