Script for Creating backup sp before modifying orginal sp

• sumankumar1983-611104

  Grasshopper

  Points: 10

  More actions

  March 11, 2010 at 3:55 am

  #219791

  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