Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I created some objects in MS SQL Server 2008 using SubSonic 3. It created them based on the user specified in connection string like:


but for some reason I am not able to test_user account. Now I am not able to access the tables within test_user schema. Is there any way to transfer schema from test_user to dbo so that any login can access it?

share|improve this question
up vote 3 down vote accepted

ALTER AUTHORIZATION ON test_user.table1 TO dbo


ALTER SCHEMA dbo TRANSFER test_user.table1

The older sp_changeobjectowner is deprecated

Some FYI: SQL: transfer database schema

share|improve this answer
I had used Alter Schema dbo Transfer..., Alter Authorization is new thing for me. But I think Alter Authorization should be better as Schema Transfer can cause problem if sys.objects is used for any functions as per MSDN – TheVillageIdiot Sep 1 '11 at 3:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.