Home
Topics
Microsoft SQL Server Administration
SQL Server Stored Procedures
How can I export stored procedures in SQL Server 2005?

Ask the Expert

How can I export stored procedures in SQL Server 2005?

Roman Rehak, Contributor

How can I export stored procedures in SQL Server 2005?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

In SQL Server Management Studio, go to Object Explorer and navigate to the database. Right-click the database and select Tasks->Generate Scripts. A wizard will open. Follow the steps and you will be able to select all or individual database objects, including stored procedures. At the end of the wizard you can chose to script to the clipboard, a text file or a new query window.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- library
- trigger

This was first published in February 2008

There are Comments. Add yours.

Sort by: Oldest Newest

Next

View All Comments

Back to top

More from Related TechTarget Sites

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

Business Analytics
- BI and analytics tools top list of planned 2014 software initiatives
  
  TechTarget's IT Priorities Survey shows that business intelligence, analytics and data warehousing projects are the top software priority this year.
- Self-serve analytics systems allow business users to wear analyst hat
  
  Data visualization and self-service analytics systems are allowing businesses to cut out the data scientist and put analysis on business users.
- IDC analysts see more Internet of Things projects ahead
  
  At IDC Directions, analysts predict more Internet of Things projects in the near future.
Data Center
- IT's vendor evaluation criteria change -- again
  
  IT departments want to shrink their list of suppliers -- but should it be longer? Cloud, mobility and big data have IT rethinking vendor selection.
- Red Hat open source innovation reactions abound from the Twitterati
  
  It was all about openness at the Red Hat Summit 2014. From OpenShift to OpenStack to open source innovations, Red Hat was buzzing about the cloud.
- Database performance tuning: Five ways for IT to save the day
  
  IT teams can play heroes when database performance issues disrupt applications. Try these five tips for performance tuning before there's a problem.
Data Management
- Big data careers: Taking the initiative to improve your skill set
  
  Expert Matt Mueller offers advice to data management pros who are interested in developing their big data skill set.
- Supermarket co-op stocks up on big data platform to help spur sales
  
  Co-operative Allegiance Retail Services is deploying a cloud-based big data stack to replace a homegrown system that fell short on analytics power.
- Think Big Analytics' Bodkin: Big data adoption means breaking silos
  
  Hadoop has the ability ultimately to break down siloed data stores, Ron Bodkin says in a Q&A.;
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle implementation at Celcom brings IT, business together
  
  Malaysia's largest cellular provider made a comeback due partly to the rapid deployment of an Oracle-based customer experience management system.
- Willis develops app to put a personal touch back in voluntary benefits
  
  Part two of a two-part article: Willis uses PeopleSoft 9.1 to bring back the personal feel to automated insurance selection for voluntary benefits.
- Willis develops app for real-time voluntary benefit selection
  
  Part one of a two-part article: Willis uses PeopleSoft 9.1 to create real-time automated insurance selection for voluntary benefits.
Content Management
- Better user adoption of SharePoint ECM needs a flexible approach
  
  For widespread adoption of SharePoint ECM features, find out how users work and be ready to adapt to their processes.
- SharePoint social success starts with a collaborative culture
  
  For SharePoint social features and other social collaboration tools to pay off, organizations need to build a culture in which sharing is rewarded.
- Oracle WebCenter emancipates users and processes at Faribault Foods
  
  After comparing Oracle WebCenter with OpenText, Faribault Foods chose Oracle document management because of its feature set and ecosystem.
Windows Server
- Have a simple Work Folders setup in Windows Server 2012 R2
  
  Follow these steps to have the easiest Work Folders setup possible and to make the feature an essential part of your enterprise.
- Windows Server 2012 R2 updates come alongside light Patch Tuesday
  
  An RTF exploit gets patched for Microsoft Office in this month's Patch Tuesday update. Plus, Microsoft updates server and client OSes.
- Microsoft Azure continues cloud pricing game of limbo with AWS, Google
  
  Microsoft will lower its Azure cloud prices to match price cuts made by AWS and Google, but is it enough to attract new customers?

All Rights Reserved,Copyright 2005 - 2014, TechTarget