InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:49:59 GMT20http://www.sqlservercentral.com/Forums/Topic1039605-149-1.aspxdeclare @name sysnameselect top 1 @name=SPECIFIC_NAME from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='ABC'while (@name is not null)beginexecute( 'ALTER SCHEMA XYZ TRANSFER ABC.' + @name);select top 1 @name=SPECIFIC_NAME from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='ABC'EndTue, 28 Dec 2010 08:13:23 GMTnekonecnyhttp://www.sqlservercentral.com/Forums/Topic1039605-149-1.aspxExport the stored procedures out to a script or set of alter scripts. Make the changes in the scripts. Run the scripts against the server. For a mechanism to automate this you might look at Red Gate's tool, [url=http://www.red-gate.com/products/sql-development/sql-prompt/]SQL Prompt[/url], which has a bunch of automatic refactoring mechanisms, just like this.Tue, 28 Dec 2010 08:04:54 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1039605-149-1.aspxHello I 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:24:32 GMTmanoharanpraveen