Home
Topics
Microsoft SQL Server Platforms
Microsoft SQL Server 2005
Copy stored procedure between SQL Server 2005 databases

Copy stored procedure between SQL Server 2005 databases

Can you tell me how to copy stored procedures (16155) from one database to another on the same SQL Server 2005?

Requires Free Membership to View

Login

By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

On SQL Server 2005, you can choose to script the stored procedures. Right click the database, then Tasks → Generate Scripts. Step your way through the wizard until you get to the option to select object types and just choose Stored Procedures. On the last page of the wizard, you can choose to send the script to a new query window. You'll need to change the database name at the top of the script and execute it against the other database.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- Yukon

This was first published in December 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Dow Chemical and Wyndham find analytics skills in unfamiliar places
  
  Analytics skills are a hard-to-find, yet sought-after commodity, but experts from Dow Chemical and Wyndham Rentals share ways to lessen that burden.
- Predictive analytics programs need open organizational minds
  
  Predictive analytics helps companies move forward more intelligently, particularly when they welcome new ideas on business strategies and processes.
- Mobile business intelligence brings benefits -- and barriers
  
  Developing and delivering mobile business intelligence applications poses various challenges that can derail a mobile BI strategy if not avoided.
Data Center
- Plan for IT disruptions to continue business as usual
  
  When plotting out your upgrades and agenda, make sure to include proper planning to save money and avoid frustration.
- HP unveils cloud-based IT service management product Service Anywhere
  
  HP's Service Anywhere joins several other cloud-based ITSM offerings, but questions about total cost of ownership could hamper potential sales.
- DevOps role continues growth: Is it here to stay?
  
  Competition is fierce in the tech arena. The DevOps role is a coveted one, and employers will do anything to secure the position, at least for now.
Data Management
- IBM executives, customers share 'big data' tips at Information on Demand
  
  IBM and Sprint executives took to the stage at the Information on Demand conference yesterday to talk about the best ways to make sense of 'big data.'
- Zornes connects the dots between big data and master data management
  
  Consultant Aaron Zornes believes that MDM and big data were made for one another.
- IT pros reveal benefits, drawbacks of data virtualization software
  
  Attendees at Composite Software's Data Virtualization Day conference had plenty of advice for companies considering a data virtualization project.
DataManagement UK
- Dynamic Markets: CFOs see worth in data on balance sheet
  
  About 20% of UK companies are assigning a financial value to their data, according to research sponsored by SAS. But only 16% of UK companies have a formal data management strategy.
- Data ethics: Author warns of ethical pitfalls of data collection
  
  Heedless data collection in business analytics programmes is breeding moral hazards, according to author Frank Buytendijk.
- Data visualisation success hinges on solid storytelling skills
  
  Tableau's Jock Mackinlay explains why data is inert and worthless without the twin practices of visualisation and storytelling.
Oracle
- Oracle E-Business Suite R12 upgrade aided by checklists
  
  A pre- and post-upgrade checklist will go a long way toward ensuring a successful Oracle E-Business Suite R12 upgrade.
- How to copy Oracle Database 9i to a new server
  
  Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.
- The finer points of Oracle applications and Oracle Business Accelerators
  
  DAZ consulting group's Deborah Arnold takes some time out of OpenWorld to talk about Oracle Business Accelerators and Oracle applications.
Content Management
- Information governance policy often a hard sell -- until it's too late
  
  Establishing an effective information governance policy remains a challenge because it relies on complex corporate cultural efforts, not software to turn on.
- Content is power behind managing the customer experience
  
  There are different ways to deliver content for managing the customer experience, but it's essential to use the right ones for successful CEM.
- New Gartner Magic Quadrant deems social software arena volatile
  
  Gartner's Magic Quadrant for Social Software reveals a booming market in which vendors have to make some serious contributions to stay in the game.
Windows Server
- Chkdsk improvements in Windows Server 2012 increase data availability
  
  Data availability has been an issue for admins running chkdsk, but that's no longer the case in Windows Server 2012. Here's a look at what's changed.
- Windows Server 2012 release highlights this year's top news stories
  
  Look back on the top news stories in a pivotal year for Microsoft and its Cloud OS initiative for Windows Server 2012.
- Why do I get a PowerShell error when trying to access a file?
  
  One common PowerShell error occurs because of the way PowerShell is told how to access a file. Here's how to fix it and avoid it in the future.

All Rights Reserved,Copyright 2005 - 2012, TechTarget