
	Home > Ask the SQL Server Experts > Roman Rehak - SQL Server Development and Reporting Services Questions & Answers > How can I export stored procedures in SQL Server 2005?

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

How can I export stored procedures in SQL Server 2005?

EXPERT RESPONSE FROM: Roman Rehak

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 20 February 2008
How can I export stored procedures in SQL Server 2005?

EXPERT RESPONSE
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.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL Server stored procedures
	SQL Server trigger vs. stored procedure to receive data notification
	How to use SQL Server 2008 hierarchyid data type
	SQL and SQL Server Tutorial and Reference Guide
	SQL Server stored procedures tutorial: Write, tune and get examples
	Check SQL Server database and log file size with this stored procedure
	SQL Server source code analysis and management adds database security
	Configure SQL Server Service Broker for sending stored procedure data
	Find size of SQL Server tables and other objects with stored procedure
	Track changes to SQL Server 2000 and 2005 with one simple utility
	Troubleshoot SQL Server 2005 temporary table performance problems

SQL Server 2005 (Yukon)

Tips for tuning SQL Server 2005 to improve reporting performance

SQL Server consolidation: Why it's an optimization technique

Parent-child dimensions in SQL Server 2005 with Analysis Services MDX

Using SQL Server datetime functions GETDATE, DATENAME and DATEPART

SSIS error message due to installation problem on SQL Server 2005

SQL Server data conversions from date/time values to character types

Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005

How to configure Database Mail in SQL Server 2005 to send mail

How to use rank function in SQL Server 2005

Manage traces in SQL Server 2005 Analysis Services with XMLA commands

SQL Server 2005 (Yukon) Research

Roman Rehak - SQL Server Development and Reporting Services

Manipulate column names in a SQL Server table

Licensing a standby server for SQL Server replication

SQL Server trigger vs. stored procedure to receive data notification

Storing and searching for image files in SQL Server

Can I encrypt and restore a database backup in SQL Server 2005?

Tips for tuning SQL Server 2005 to improve reporting performance

Using BULK INSERT to insert rows from SQL Server dataset to table

SQL Server query to import database names

Troubleshoot SQL Server 2005 SP2 installation error

Workaround to Reporting Services error in SQL Server Express

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

library (SearchSQLServer.com)

trigger (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2005 - 2008, TechTarget \| Read our Privacy Policy