Suppose i have used a server name in many Sps. Now the Server gets changed and so i need to update the servername in all sps.
It becomes a tedious task to go through all the sps. Instead i can run this script and get the list of Sps where that Servername is written and then just by a update statement you can update.
All the SP contents are stored in syscomments table in text field.
This script helps to get all the Sps or functions having the word Return in their contents.
select * from sysobjects where id in (select id from syscomments where text like '%Return%')
Here's a general overview for creating and editing stored procedures. Head over to the discussion forum for this article and present your creative ideas for using this powerful feature of SQL Server to the SSC community.
2002-05-27
19,660 reads
Sp_readerrorlog can read any file on the hard disk, not just error logs. Read on to learn how!
2002-02-05
1,157 reads
The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.
2007-02-09 (first published: 2001-12-18)
39,868 reads
Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
2001-08-01
12,625 reads
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads
