Solved

Copy a SQL routine into an existing SQL DB as Store Procedure

Posted on 2013-06-24
2
246 Views
Last Modified: 2013-06-24
I have a SQL routine that has been written by someone else.  I want to copy the SQL file into an existing DB as a Store Procedure to run.  It will create a list of new tables and reports to be used in the DB.

How do I do this?

Thanks

Glen
0
Comment
Question by:GPSPOW
2 Comments
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 500 total points
ID: 39272894
Simply use SSMS and copy and paste the script into the query window and run it.
0
 

Author Closing Comment

by:GPSPOW
ID: 39273278
Thank you
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now