Sql server 2005 :How to Import objects of a schema to another

I have created several objects (Tables,Stored Procs, functions etc.) u开发者_运维百科nder a new schema (x)

Now I want to import them to DBO schema.

How can I do that.. Thanks

---

You want to transfer them from your other schema so they now belong to the dbo schema? If so this is the syntax you need.

ALTER SCHEMA dbo TRANSFER OtherSchema.ObjectName;