Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
broscup
Starting Member
5 Posts |
 Posted - 2008-04-03 : 12:16:16
|
| Our DB has a large amount of tables, and whenever we update a field variable (in this case a varchar length) which we did in nearly all of the tables, we then have to go through and update the stored procedures as well. Is there a way to do this automatically, or can this only be done manually. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-03 : 12:22:27
|
| You can get the list of procedure that use a particular table. Other than that i dont think you can change all sps related to table automatically when table DDL changes. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-04 : 01:56:09
|
| Make use of sp_depends procedure,fine related procedures and change then change them accordinglyMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Updating Stored Procedures