Cannot Transfer Table to New Schema

Question

Experts--

Just created a new table (dbo.customer) and a new schema (pricing).  As far as I can tell I have full permissions for both.

I want to transfer dbo.customer to the pricing schema but get the error:

"Cannot transfer the object 'customer', because it does not exist or you do not have permission."

Not sure what the problem is here, as the table does exist, I am the owner, and have full permissions as mentioned above.

?

---

Bonediggler

Answer 1

Is it what you're using?

http://msdn.microsoft.com/en-us/library/ms173423.aspx

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Yes.  Sorry I left that out.

---

Bonediggler

Answer 3

May be the simpler solution will be to script the table (since it's new) and execute this script by using your new schema, then drop the original table. Just a workaround for your problem.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 4

That worked.  Thank you!

---

Bonediggler