Solved

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

Posted on 2014-01-13
2
226 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 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