Solved

How to take backup of SP/UDF before altering it?

Posted on 2014-01-13
2
227 Views
Last Modified: 2014-01-14
Before dropping a table we check if exist delete it. We can use INTO statement to take backup of the table.

Likewise is there any way to take the backup of SP/Function to either in the DB or in File in specified path before modifying it?

Please do suggest. Thanks in advance.
0
Comment
Question by:Easwaran Paramasivam
2 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 39776391
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 39779912
I've read your other aticles as well. Awesome. Keep doing!! Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question