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 |
|
MPDS
Starting Member
2 Posts |
 Posted - 2014-01-31 : 07:31:44
|
| Hi Guys,I need some information about find-and-replace schema's in large stored procudures. And if the schema is missing than add the new schema.Not by hand but by t-sql,These sp have more than 8000 char.Does some have a tip for me?cheersHans |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-31 : 08:51:40
|
| you mean change schema for sps alone or including all objects used inside it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
MPDS
Starting Member
2 Posts |
Posted - 2014-01-31 : 10:32:57
|
| all objects inside the sp |
|
|
|
|
|
|
changing schema's in SP