SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / change schema for stored procedure / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 06:00:28 GMT20RE: change schema for stored procedurehttp://www.sqlservercentral.com/Forums/Topic1039606-338-1.aspxAlsowww.sqlservercentral.com/Forums/FindPost995744.aspxMon, 27 Dec 2010 23:31:44 GMTJunglee_GeorgeRE: change schema for stored procedurehttp://www.sqlservercentral.com/Forums/Topic1039606-338-1.aspxHi..Just try this link..http://www.geekzilla.co.uk/View4384ACEC-8C9D-452A-83F6-230FFE43C17B.htmMon, 27 Dec 2010 23:27:52 GMTJunglee_Georgechange schema for stored procedurehttp://www.sqlservercentral.com/Forums/Topic1039606-338-1.aspxHelloI have a bunch of stored procedure(more than 200) in my database.I have to change the schema of those now. They have the schema ABC. I have to change it to XYZ,.I know [ALTER SCHEMA XYZ TRANSFER ABC.STOREDPROCEDURE] query would do.But the no of stored procedure is huge . I cannot do one by one. Is there any other way to do this task.thanksMon, 27 Dec 2010 17:25:41 GMTmanoharanpraveen