
	Home > SQL Server Tips > Database Development > Make changes to SQL Server stored procedures with batch editing

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE DEVELOPMENT

Make changes to SQL Server stored procedures with batch editing

Serdar Yegulalp
01.30.2008
Rating: -1.64- (out of 5)

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

The database system that I maintain makes extensive use of stored procedures. Most of the common tasks performed with the database are handled exclusively by 2000 and 2005 stored procedures through SQL Server stored procedures. It's often possible to make global changes to the way the system behaves by simply editing one stored procedure in SQL Server. However, sometimes you need to change a whole slew of stored procedu

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL Server Stored Procedures
	Top 10 SQL Server development tips of 2008
	SQL Server trigger vs. stored procedure to receive data notification
	SQL Server errors, failures and other problems fixed from the trenches
	SQL Server and data manipulation in T-SQL
	How to use SQL Server 2008 hierarchyid data type
	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

Microsoft SQL Server Performance Monitoring and Tuning

Performance implications of transaction log autogrowth in SQL Server

The short course on how SQL Server really works

Determining the source of full transaction logs in SQL Server

Improving SQL Server full-text search performance

New GROUP BY option provides better data control in SQL Server 2008

Microsoft SQL Server 2008 Resource Governor primer

Examining data files when SQL Server tempdb is full

Testing transaction log autogrowth behavior in SQL Server

Meeting business needs with SQL Server full-text search

Using dynamic management views to improve SQL Server index effectiveness

Database Development

Managing the development lifecycle with Visual Studio Team System 2008

Processing XML files with SQL Server functions

A first look at Visual Studio Team System 2008 Database Edition

How to create a SQL inner join and outer join: Basics to get started

New datetime data types in SQL Server 2008 offer flexibility

Using DATEADD and DATEDIFF to calculate SQL Server datetime values

SQL Server database design disasters: How it all starts

SQL Server database design disasters: What not to do

Secure SQL Server from SQL injection attacks

Check SQL Server database and log file size with this stored procedure

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

res all at once -- which is the kind of surgery you want to perform as delicately as possible. This, of course, assumes you're not using Visual Studio or some other IDE to perform this kind of work, which takes a lot of the drudgery out of it.

Here is my basic approach to making changes to a group of stored procedures in SQL Server:

[TABLE]

Rate this Tip

To rate tips, you must be a member of SearchSQLServer.com.
Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SQL Server Development - .NET, C#, T-SQL, Visual Basic

SEARCH

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


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