Hi Vinay, nice script. Liked both your scripts for objects copying across schemas. Just wanted to share this other way to add SQL objects to multiple database on a server.

http://www.sqlservercentral.com/Forums/Topic1168030-9-1.aspx

If you wanted to add a SQL table or view or any SQL object to multiple database on your server and do not want to execute the script over and over again in all the multiple databases than the following SQL script can be used.

There have been instances where I had to add a stored procedure or a table in multiple client database as a part of the schema change process and this script has come in handy.

--ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.

I have a question again... Can we move one table \ multiple tables from one schema to multiple schemas along with all the properties (identiy column, default values, primary key, Cluster and non-cluster indexes)