Change schema and related stored procedures | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Change schema and related stored procedures

Hello everybody , i’m asking if there an easy way to alter some Stored procedures (lots) to reflect the transfering of some tables to a new created schema without using synonyms. i mean , is there some kind of automated process that updates the text of the SPs , for example updating the syscomments table ???!!! i will appreciate any feedback
SQL Server 2005 Books Online ALTER SCHEMA (Transact-SQL) ALTER SCHEMA HumanResources TRANSFER Person.Address; You can write a script to loop through all procedures which requires schema change… MohammedU.
Moderator
SQL-Server-Performance.com
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |