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.