Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

test_user.table1

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
add comment

1 Answer

up vote 3 down vote accepted

ALTER AUTHORIZATION ON test_user.table1 TO dbo

OR

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
add comment

Your Answer

 
discard

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.