Script for Creating backup sp before modifying orginal sp

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Script for Creating backup sp before...

Script for Creating backup sp before modifying orginal sp

Rate Topic

Display Mode

Topic Options

Author

Message

sumankumar1983-611104

Posted Thursday, March 11, 2010 3:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 13, 2012 3:57 PM
Points: 2, Visits: 30

My requirement is to write one script that will create a backup of sp,so that if I modify sp I will have one backup sp if some thing goes wrong,I can revert the changes.

For example I have sp USPCreateEnterprise so before doing modification in USPCreateEnterprise I want to make sure to create sp USPCreateEnterprise_03_11_2010_Bak and then I want to modify USPCreateEnterprise.I can take backup of sp throgh sp_helptext also and manually saving it to some files or creating it.

But my requirement is to I will just pass sp name and script should create backup of input sp with date appended in sp Name.

Thanks in advance

Suman

Post #880862

« Prev Topic | Next Topic »

Permissions